saving excel file as tab delimited

[kirshru]

i am trying to save a excel file , and one of the cells in the file ha
a string with a ',' and when saved as a tab delimited file , ""[Doubl
Quotes] are printed around the string that was in the cell.

EG:

NOTE: If conduit is needed*, it * must be in place before vendors ar
dispatched to complete any site work

when saved as tab delimted file is saved as

\" [/B] NOTE: IF CONDUIT IS NEEDED, IT MUST BE IN PLACE BEFORE VENDOR
ARE DISPATCHED TO COMPLETE ANY SITE WORK\"

I do not want to see double quotes around the string in the ta
delimited file.

 

[Dave Peterson]

If I had to do special stuff, I'd start with Earl Kiosterud's Text Write
program:

www.smokeylake.com/excel
(or directly: http://www.smokeylake.com/excel/Text Write Program.htm)

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

======

If you want to try to write your own, here are a couple more samples:

Chip Pearson's:
http://www.cpearson.com/excel/imptext.htm

J.E. McGimpsey's:
http://www.mcgimpsey.com/excel/textfiles.html

i am trying to save a excel file , and one of the cells in the file has
a string with a ',' and when saved as a tab delimited file , ""[Double
Quotes] are printed around the string that was in the cell.

EG:

NOTE: If conduit is needed*, it * must be in place before vendors are
dispatched to complete any site work

when saved as tab delimted file is saved as

\" [/B] NOTE: IF CONDUIT IS NEEDED, IT MUST BE IN PLACE BEFORE VENDORS
ARE DISPATCHED TO COMPLETE ANY SITE WORK\".

I do not want to see double quotes around the string in the tab
delimited file.

A

 

[Guest]

Has this bug been addressed? Saving a sheet as tab-delimited text should not
alter the data in any cells.