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
Saziz

[Tom Ogilvy]

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

[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 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

[saziz]

Both the solutins worked.
Thank you
Saziz