View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Jerry Jerry is offline
external usenet poster
 
Posts: 142
Default 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