download a .csv file to Excel
 

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 wrote:
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?

Find and Replace. Find ' replace with - nothing!

--
Interim Systems and Management Accounting
Gordon Burgess-Parker
Director
www.gbpcomputing.co.uk

Thanks! How obvious and yet it never occured to me!!!

"Gordon" wrote:

acwerth wrote:
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?

Find and Replace. Find ' replace with - nothing!

--
Interim Systems and Management Accounting
Gordon Burgess-Parker
Director
www.gbpcomputing.co.uk

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

"Gordon" wrote:


acwerth wrote:

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?

Find and Replace. Find ' replace with - nothing!


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

--
Interim Systems and Management Accounting
Gordon Burgess-Parker
Director
www.gbpcomputing.co.uk