Do you mean there are not commas separating the text? If you do have
commas, Text to columns would work using the comma as the delimiter.

If there are commas then when you chose Text to Columns, use the
Delimited option instead of Fixed and select the comma as the
delimiter.

If there are no commas use the quotation mark as the delimiter by
selecting the Other option and typing in a ". When you hit next, you
will have blank columns in between your desired text. Click on a blank
column in step three and chose the Do Not Import option. Do this for
each of the blank columns then click Finish.

Does that help?


Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=529257