download a .csv file to Excel

A

acwerth

I am downloading data from a web based data base and it delivers the file as
a *.csv file. When I open the file on my computer, the data in each cell is
in quotations ie: 'name' 'address' etc. How do I remove these quotation marks?
 
G

Gordon

acwerth said:
I am downloading data from a web based data base and it delivers the file as
a *.csv file. When I open the file on my computer, the data in each cell is
in quotations ie: 'name' 'address' etc. How do I remove these quotation marks?
Click to expand...

Find and Replace. Find ' replace with - nothing!
 
G

Gordon

acwerth said:
Thanks! How obvious and yet it never occured to me!!!

:
Click to expand...

If you're not used to dealing with csv files, it's not something you
would immediately think of!
 
Top