Hi.
The best way to do this would be to select the data you wish to
separate, and select
datatext to columns
Select the delimited type, and click next.
Check the box under delimiters where it says "space" and click next.
then finish.
Hope this Helps,
Andrew G


--
carlito_1985
------------------------------------------------------------------------
carlito_1985's Profile: http://www.excelforum.com/member.php...o&userid=21390
View this thread: http://www.excelforum.com/showthread...hreadid=467731