Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.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 |
#3
Posted to microsoft.public.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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I save a 40meg 26,000 row file to Space Delimited format | Excel Discussion (Misc queries) | |||
Output space-delimited file with quotes around text? | Excel Discussion (Misc queries) | |||
Saving as Text (tab delimited) surrounds text with "quotes" | Excel Discussion (Misc queries) | |||
Need quotes around exported tab delimited text | Excel Discussion (Misc queries) | |||
How do I save format changes in a comma delimited file? | Excel Worksheet Functions |