ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Double quotes in cell and converting to CSV (https://www.excelbanter.com/excel-discussion-misc-queries/138022-double-quotes-cell-converting-csv.html)

ewood6

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.

joel

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