How to stop Excel from inserting quotation marks into TXT files

[Dan Falk]

When I save an Excel file as a Text Tab delimited file, the resulting file
has quotation marks inserted at the front and back of any line which
contained a comma. Also, any quotation marks in the original file are
duplicated around the original quotation marks.

===================
For example this:
asd asd, asd asd asd asd asd
becomes:
"asd asd, asd asd asd asd asd"
and this:
asd asd "asd" asd asd asd asd
becomes:
asd asd ""asd"" asd asd asd asd
===================
Is there a way to keep Excel from doing this?

Thanks for your help with this.

Regards,
Dan Falk

 

[Dave Peterson]

You could use a macro and write code and have complete control over what you
write.

Here are three sites that you could steal some code from:

Earl Kiosterud's Text Write program:
www.smokeylake.com/excel
(or directly: http://www.smokeylake.com/excel/text_write_program.htm)

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

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