Earl Kiosterud's free TEXTWRITE.xls workbook will do what you want.
http://www.smokeylake.com/excel/text_write_program.htm
Gord Dibben MS Excel MVP
On Wed, 21 Oct 2009 12:14:02 -0700, Sninkle
wrote:
This may vary depending on whcih version of Excel you are using.
I know that you can save Excel into a delimited text file based on comma,
space or tab via Save As.
"HotPepper" wrote:
It would be nice if Excel had the ability when saving a delimited text file
to be able to specify the delimiter, and whether or not you wanted a text
qualifier such as double quotes around the text. This should be available
from the workbook and accessible through VBA.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/comm...lic.excel.misc