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