| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Cell content surrounded by quotes when saving as tab delimited for
When performing a "Save as" a "Tab (delimited)" file in Excel 2000, cells
contents that contain a comma are automatically surrounded by double quotes ("). Is there a way to save a file in tab delimited format without Excel automatically encapsulating text data that contain commas with double quotes? This appears to be a known issue, but I have not been able to find a solution. Tried to open the saved file in Note Pad and perform a find and replace, but the file is too big and consequently freezes application. Thanks, Jerry |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| comma delimited & surrounded by quotes | Excel Discussion (Misc queries) | |||
| Output space-delimited file with quotes around text? | Excel Discussion (Misc queries) | |||
| How do I preserve cell content when saving an excel file in csv | Excel Discussion (Misc queries) | |||
| Saving as Text (tab delimited) surrounds text with "quotes" | Excel Discussion (Misc queries) | |||
| Need quotes around exported tab delimited text | Excel Discussion (Misc queries) | |||
Threaded Mode
