Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.misc
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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
display double quotes in an cell rpurosky Excel Discussion (Misc queries) 6 December 1st 06 05:50 PM
Save As CSV, double quotes Zamdrist Excel Discussion (Misc queries) 1 October 30th 06 07:40 PM
convert spreadsheet to csv with double quotes Bren Lane Excel Discussion (Misc queries) 3 September 19th 06 01:02 AM
How to get double quotes to show up after pasting? SusanG Excel Worksheet Functions 2 July 24th 06 05:39 PM
Escape character for double quotes SteveFox Excel Worksheet Functions 5 December 23rd 05 10:54 PM


All times are GMT +1. The time now is 10:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"