| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| display double quotes in an cell | Excel Discussion (Misc queries) | |||
| Save As CSV, double quotes | Excel Discussion (Misc queries) | |||
| convert spreadsheet to csv with double quotes | Excel Discussion (Misc queries) | |||
| How to get double quotes to show up after pasting? | Excel Worksheet Functions | |||
| Escape character for double quotes | Excel Worksheet Functions | |||
Hybrid Mode
