how to seperate into columns?

B

bufhal

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

Here is an example:


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



I appreciate any help
 
S

Sloth

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

Nancy

If you open a blank spreadsheet, and then go to the data menu and choose to
import external data, You can find that file that you want to import. Then,
there is a wizard that will come up. One of the screens in that wizard asks
what the delimator is. That is where you choose the comma. Right now, it
looks as though it doesn't know that the comma is supposed to make it skip to
the next cell.
 
Top