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 |
Cell content surrounded by quotes when saving as tab delimited for
Supplemental:
Found a Microsoft Knowledge Article 104997 that specifically deals with this issue called "Macro to Save Data as Tab-Delimited File without Quotes" at http://support.microsoft.com/default...;en-us;Q104997 However, I was not successful with same. Either there is a step missing or it's too complicated for me to follow. "Jerry" wrote: 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 |
Cell content surrounded by quotes when saving as tab delimited for
Maybe you could write your own exporting program that would behave exactly the
way you want: 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 (or maybe you could build your own formula and copy|paste into Notepad.) Check out Earl's Text Write program first. It may do exactly what you want right out of the box. Jerry wrote: 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 -- Dave Peterson |
All times are GMT +1. The time now is 10:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com