Separating string of numbers into single cells.

[serge]

Hi,

I have in cell A5 : 02 06 10 25 39 and would like to separate those numbers into 1 cell each like below starting from cell B5:F5.

02 06 10 25 39 = 2 6 10 25 39

Thank you

[TABLE="width: 125"]
<tbody>[TR]
[TD="width: 125"][/TD]
[/TR]
</tbody>[/TABLE]

 

[jtakw]

Hi,

B5 formula copied across as far as needed (down and across if you have more rows of data):

Book1
	A	B	C	D	E	F
5	02 06 10 25 39	2	6	10	25	39
Sheet170

Cell Formulas
Range	Formula
B5	=IFERROR(MID(SUBSTITUTE($A5," ",REPT(" ",30)),COLUMNS($B5:B5)*30-29,15)+0,"")

 

[PCL]

Try
Select A5
Data > Text to Columns >Delimited > Space

 

[serge]

Thank you very much jtakw, thats what I needed, I appreciate your help.
Serge

 

[serge]

Thanks PCL, but I was looking for a formula, thank you.

 

[jtakw]

Thank you very much jtakw, thats what I needed, I appreciate your help.
Serge

You're welcome, serge.

On second thought, might want to change the 15 to 30 in my formula, just in case you have long number strings:

Book1
	A	B	C	D	E	F
5	02 06 10 251234567890123 39	2	6	10	251234567890123	39
Sheet170

Cell Formulas
Range	Formula
B5	=IFERROR(MID(SUBSTITUTE($A5," ",REPT(" ",30)),COLUMNS($B5:B5)*30-29,30)+0,"")

 

[Rick Rothstein]

Here is another formula (placed in cell B5) that you can use...

=TRIM(MID(SUBSTITUTE(" "&$A5," ",REPT(" ",99)),COLUMNS($B:B)*99,99))

 

[serge]

Thank you Rick, I appreciate your help.
Serge.