Separate one cell into 11
 

How do I separate one cell containing "1041 305 15 3 0 6 37 0
0 2 14" into 11 cells each containing one number? Space indicates the
end of the number. I need to repeate this formula for every row.
Thanks.

Separate one cell into 11
 

Instead of using a formula, you could try:

Insert a few columns to the right of your data.
Data|text to columns (xl2003 menus)
Delimited by space
(and treat consecutive delimiters as one)



Vic wrote:

How do I separate one cell containing "1041 305 15 3 0 6 37 0
0 2 14" into 11 cells each containing one number? Space indicates the
end of the number. I need to repeate this formula for every row.
Thanks.

--

Dave Peterson

Separate one cell into 11
 

2 ideas:
1) Use data - text to columns, with a space as delimiter, then copy - pate
special - transpose, to get the data into rows

2) Use the following formula copied down until you get an error
=RIGHT(A1,LEN(A1)-FIND(" ",A1))
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Vic" wrote:

How do I separate one cell containing "1041 305 15 3 0 6 37 0
0 2 14" into 11 cells each containing one number? Space indicates the
end of the number. I need to repeate this formula for every row.
Thanks.