Help with Col. split

[saziz]

Hi Group,
I have few sheets with col containing data " 123 4567"
I want this to be split in 2 dif col where space occurs.
sometimes there are 4 digits in first set like "1234 5678"
Any help would be apprecited.
Thanks
Sazi

 

[Guest]

select the column,

do Data=>Text to Columns

selected delimited

then select space as the delimiter

 

[Dave Peterson]

Say your string is in A1.
Put this in B1: =LEFT(TRIM(A1),SEARCH(" ",TRIM(A1))-1)
put this in C1: =MID(TRIM(A1),SEARCH(" ",TRIM(A1))+1,255)

if you want real numbers (not strings), use these:
Put this in B1: =--LEFT(TRIM(A1),SEARCH(" ",TRIM(A1))-1)
put this in C1: =--MID(TRIM(A1),SEARCH(" ",TRIM(A1))+1,255)

 

[saziz]

Both the solutins worked.
Thank you
Saziz