how can i repeat one thing to a row?

[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??

 

[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

 

[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.