View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jjk98 jjk98 is offline
external usenet poster
 
Posts: 14
Default Double quotes when exporting to tab delimited file

When exporting a worksheet to a tab delimited text file (.txt), fields
explicitly typed as text which contain a double quote (") are changed by
replacing each occurence of the single " with a pair of them.

For example the text in the spreadsheet reads: "Tin Foil" Revenues the
exported text is ""Tin Foil"" Revenues.

How do I stop this action? I have Excell 2007 and my spreadsheet has many
thousands of quoted strings.
--
Thanks for your help - jjk98