Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel XP: File name in Title Bar not changed after Save As... | Excel Discussion (Misc queries) | |||
Excel 2003: File->Close without saving changes (save menu does no. | Excel Discussion (Misc queries) | |||
'document not saved' for 'save' or 'save as' an EXCEL file | Excel Discussion (Misc queries) | |||
Challenging Charting | Charts and Charting in Excel | |||
I used Save instead of Save As in Excel. How can I get my origin. | Excel Discussion (Misc queries) |