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
becomes:
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 replied on 13-Apr-07 10:54 AM
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


--

Dave Peterson