Double quotes in cell and converting to CSV

E

ewood6

In my document the cells in the last column contain double quotes. When I
save as a CSV file I can't get that field to be just the double quotes. What
do I need to do? I'm using Excel 2002.
 
J

Joel

You may need to edit the csv file in Notepad and replace the two sets of
quotes with one set of quotes. Excel defaults to taking actual quotes and
saving them as two quotes.

You can write a macros that wuld save the file with out the double quote but
that means writing a macro. Microsoft products havve options for import data
witth the double quotes. Check the program that is reading the csv file and
see if double quotes can be replace with single quotes.
 

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

Top