![]() |
Double quotes in cell and converting to CSV
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. |
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. |
All times are GMT +1. The time now is 10:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com