Double quotes bracketing text strings that include commas



Excel 2007 has this nasty feature that brackets text strings with a pair of
double quotes when outputting them to a tab-delimited (.txt) file, if the
text string contains a comma.

This is apparently new with the 2007 edition.

Anyone know how to disable this "feature"?


Dave Peterson

xl2003 does the same thing--and I didn't test, but I don't think that this
behavior has changed from earlier versions.

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:

Chip Pearson's:

J.E. McGimpsey's:

Earl's program may work right out of the box.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question