LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default Excel saving as textfile quotes issue

Hi,

i'm having an issue trying to save an excel file containing cells with
multiple values separated by commas.

for example, i have in a cell of the excel file:

myField1,myField2


I want to save it in a text file format and i'm not happy because the
resulting txt file is:

"myField1,myField2"

I do not want these "" in the text file. Is there a way to cope with
that?

Thank yiu

 
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
Excel 2003 inserts quotes when saving SS as text and comma is pres mklapp Excel Discussion (Misc queries) 1 June 4th 08 10:01 PM
when excel save as csv,double quotes in an cell issue frank Excel Discussion (Misc queries) 0 October 26th 07 03:14 AM
Why Saving a file to a CSV, Excel does not put text into Quotes? Paul Bytes Excel Discussion (Misc queries) 1 January 26th 07 03:59 PM
Issue with Excel Macro. Unable to insert quotes before and after the text. Vamsi Excel Programming 2 July 9th 04 06:43 AM
Opening and saving textfile into XLS MicMast Excel Programming 1 August 4th 03 01:33 PM


All times are GMT +1. The time now is 01:51 PM.

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"