Excel 2007 Saving Tab Delimited File With Text Without Quotes


  • How does one turn off the feature within Excel 2007 that quotes text strings with embedded commas given the delimiter is tab (not a comma)?

    Using the SaveAs method with FileFormat xlTextWindows, the resulting tab delimited file quotes text strings with embedded commas.

    Other solutions include saving the file as a tab delimited file and reprocessing the the tab delimited file to strip out the quotes.

    Is quoting the text string for a tab delimited file so entrenched within Excel that the solution is to make a second pass at the file?

    Thursday, October 03, 2013 6:10 PM


All replies