View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Double quotes in cell and converting to CSV

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.

"ewood6" wrote:

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.