| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Tab delimited text file import on double click | Excel Discussion (Misc queries) | |||
| comma delimited & surrounded by quotes | Excel Discussion (Misc queries) | |||
| Output space-delimited file with quotes around text? | Excel Discussion (Misc queries) | |||
| Exporting single or double quote delimited files | Excel Worksheet Functions | |||
| how do I create comma and double quote delimited file | Excel Discussion (Misc queries) | |||
Threaded Mode
