how can i repeat one thing to a row?

B

brenda

hi i want to know how to do a thing to all the rows

well what i mean is
im writting number in one colum n want to do the same thing to the other rows

i want to do this

1 2 2 3 1
in one coloum n im doing that for many rows is there a way to just write
numbers and the spaces between come actomatically

or i have to write one number then space bar second number then space bar??
 
P

Pete_UK

If you put 12231 in A1 and this formula in B1:

=LEFT(A1,1)&" "&MID(A1,2,1)&" "&MID(A1,3,1)&" "&MID(A1,4,1)&"
"&RIGHT(A1,1)

you will get 1 2 2 3 1 displayed. So, enter the numbers without spaces
in column A, and then copy the formula down as many rows as you need.

Hope this helps.

Pete
 
R

Roger Govier

Hi Brenda

You could do this with formatting.
Mark the column>Format>Cells>Number>Custom # # # # #>OK

Then as you enter the numbers, they will be spaced out.
 
Top