viewing CSV file in Excel-2000

  • Thread starter Thread starter aa
  • Start date Start date
A

aa

I 've got my bank statement as a CSV text file but my Excel2000 fails to
recognise comma as a fiel separator and places each record into a single
cell. How do I get round this?
 
Excel uses the windows separator for its list separator.

You could go into the control panel|regional settings and make the list
separator the comma. But since this is a windows setting, you may find you've
caused other problems.

Alternatives would be to rename the .csv file to .txt and when the import data
wizard appears (after you do File|Open), you can specify that it a text file
delimited by commas.

Or since the data is in a single column already, just select that column and use
Data|Text to columns. Then choose delimited by a comma.
 
Back
Top