"s when saving to text

Giganews Newsgroups
Subject: "s when saving to text
Posted by:  a (..@b.com)
Date: Fri, 7 May 2004

Hello,

I'm trying to save a large quantity of text contained in an Excel worksheet
as a text file i.e. SaveAs and then changing file type to .txt.
Unfortunately, if a cell contains a leading space, a trailing space, or any
quotation marks, the text file produced will surround that text with
quotation marks. Is there any way to prevent the quotaion marks from being
added so that it just saves the file as it is displayed in the spreadsheet?

Any help greatly appreciated
/Dom

Replies