| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| I get a program error when I download an excel template | Excel Discussion (Misc queries) | |||
| How Do I open an excel file without Excel Viewer support | Excel Discussion (Misc queries) | |||
| import .CSV file to XP EXcel 2003 worksheet, the seperator is com. | New Users to Excel | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Linear Mode
