how can i repeat one thing to a row?
 

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

how can i repeat one thing to a row?
 

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

On Feb 10, 1:28*am, brenda wrote:
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??

how can i repeat one thing to a row?
 

Hi Brenda

You could do this with formatting.
Mark the columnFormatCellsNumberCustom # # # # #OK

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

--
Regards
Roger Govier

"brenda" wrote in message
...
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??