Excel - How to stop Excel from inserting quotation marks into TXT files

Asked By Dan Fal on 13-Apr-07 10:20 AM
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
and this:
asd asd "asd" asd asd asd asd
asd asd ""asd"" asd asd asd asd
Is there a way to keep Excel from doing this?

Thanks for your help with this.

Dan Falk

Dave Peterson replied on 13-Apr-07 10:54 AM
You could use a macro and write code and have complete control over what you

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

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

Chip Pearson's:

J.E. McGimpsey's:


Dave Peterson