don't insert quotes in excel save as tab-delim txt
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/comm...lic.excel.misc |
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 "Naomi" wrote in message ... 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/comm...lic.excel.misc |
All times are GMT +1. The time now is 08:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com