download a .csv file to Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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!
 
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!
 
You must log in or register to reply here.

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

Similar Threads

Single Quotation mark in CSV 1
Save Excel file to CSV with quotation mark data delimeter? 2
Excel CSV Files; Creating Of 3
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Changing commas in .csv to quotation marks 1
CSV->Excel Data Problem 1
csv files 1
Saving text with commas in a .csv file then converting to a .txt f 3

Back
Top