View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Double quotes bracketing text strings that include commas

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

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

ExcelStudent wrote:

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"?

Tom


--

Dave Peterson