As long as each has a SPACE between them, Text To Columns WILL work.
Follow these instructions:

Select the range of data
On the main menu, click DataText to Columns...
In the box that opens, make sure "Delimited" is selected as "Original
data type"
Click Next
In the Delimiters section, Uncheck all EXCEPT "Space" (if you want to
eliminate the commas or slash, you can list those as well (you can have
only one 'other' delimiter-you could rerun TTC to eliminate the
backslash))
Click Next
Verify the Destination meets your needs
Click Finish

Regardless of the number of characters between spaces, each space will
begin a new column.

Good Luck


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=475981