LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey
 
Posts: n/a
Default Triple Quotes when saving to *.csv

See

http://www.mcgimpsey.com/excel/textfiles.html

for one way.

In article ,
"D" wrote:

When saving the file as *.csv, some text (brought up in notebook) has no
quotes around it (i.e. text) and text with quotes around it has triple quotes
around it (i.e. """text"""). Any help on how to save an excel file as a *.csv
and have all text have double quotes around it (i.e. "text"), when read in
notebook?

Thank you

 
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
Problem saving the file after moving worksheets into another SteveD62226 Excel Discussion (Misc queries) 0 November 18th 05 10:01 PM
Triple occurence formula toyota58 Excel Worksheet Functions 1 August 19th 05 10:43 AM
How do I stop Excel 2000 from saving file history from file that . Cathy Excel Discussion (Misc queries) 0 March 29th 05 03:27 PM
why are there quotes in my exported text file? Gordon Excel Discussion (Misc queries) 2 February 16th 05 06:59 PM
saving excel file as tab delimited Craig Hilliard Excel Discussion (Misc queries) 0 February 1st 05 10:39 PM


All times are GMT +1. The time now is 12:41 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"