highlight the cell you want to break up. Click Data-Text to Columns.
Choose Delimited and select next. Choose comma, and hit finish.

"bufhal" wrote:


Hope someone can help me.
I have a text file that when I open in Excel, all the comma delimited
fields are in the "A" column. I need all these records to be in
different columns.

Here is an example:


DATE,"TIME","ID","FNAME","LNAME","SUFFIX","TITLE", "COMPANY","ADDRESS1","ADDRESS2","CITY","ST","COUNT RY","ZIP_CODE","PHONE","FAX","CODES","EMAIL



I appreciate any help.


--
bufhal
------------------------------------------------------------------------
bufhal's Profile: http://www.excelforum.com/member.php...o&userid=10702
View this thread: http://www.excelforum.com/showthread...hreadid=501695