viewing CSV file in Excel-2000



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?

Dave Peterson

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.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question