Help with Col. split
 

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

--
sazi
-----------------------------------------------------------------------
saziz's Profile: http://www.excelforum.com/member.php...nfo&userid=635
View this thread: http://www.excelforum.com/showthread.php?threadid=57088

Help with Col. split
 

select the column,

do Data=Text to Columns

selected delimited

then select space as the delimiter

--
Regards,
Tom Ogilvy


"saziz" wrote:


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
Saziz


--
saziz
------------------------------------------------------------------------
saziz's Profile: http://www.excelforum.com/member.php...fo&userid=6350
View this thread: http://www.excelforum.com/showthread...hreadid=570887

Help with Col. split
 

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 wrote:

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
Saziz

--
saziz
------------------------------------------------------------------------
saziz's Profile: http://www.excelforum.com/member.php...fo&userid=6350
View this thread: http://www.excelforum.com/showthread...hreadid=570887

--

Dave Peterson

Help with Col. split
 

Both the solutins worked.
Thank you
Saziz


--
saziz
------------------------------------------------------------------------
saziz's Profile: http://www.excelforum.com/member.php...fo&userid=6350
View this thread: http://www.excelforum.com/showthread...hreadid=570887