View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default Saving in text format: why are there ""?

That usually is the case if you are saving as a delimited file and the
contents of the cell contains the delimiter within. Remove that situation
and you shouldn't get the double quotes.

Or save the file as fixed space so there are no delimiters.

or you can write code to create the file to fit your specifications. Here
is a start:
http://www.cpearson.com/excel/imptext.htm import/export text files

--
Regards,
Tom Ogilvy


"Rafael" wrote:

I am trying to save data from an excel spreadsheet under .txt format. However
the final format has quotes "" at the begining and end of certain lines. How
do I get rid of them?