How to stop Excel from inserting quotation marks into TXT files

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top