Save delimited format, specify delimiter, remove quotes from text
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 |
Save delimited format, specify delimiter, remove quotes from text
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 |
Save delimited format, specify delimiter, remove quotes from text
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 |
All times are GMT +1. The time now is 07:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com