don't insert quotes in excel save as tab-delim txt

[Naomi]

I wish to export from an excel spreadsheet file to a tab-delimited text file
- WITH NO QUOTES around any of the entries. They are not necessary, because
tabs - not commas are the delimiters. I was quite disappointed that from
changing to the older version of excel, which had a configurable export
function, where I could specify "no quotes please" to excel 2000, I cannot
specify this.

----------------
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/com...a-5309522e93c6&dg=microsoft.public.excel.misc

 

[David McRitchie]

Hi Naomi,
If you can use a macro solution you can modify the export within.
http://www.cpearson.com/excel/imptext.htm
The TAB character is CHR(9)

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

I wish to export from an excel spreadsheet file to a tab-delimited text file
- WITH NO QUOTES around any of the entries. They are not necessary, because
tabs - not commas are the delimiters. I was quite disappointed that from
changing to the older version of excel, which had a configurable export
function, where I could specify "no quotes please" to excel 2000, I cannot
specify this.

----------------
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/com...a-5309522e93c6&dg=microsoft.public.excel.misc