| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Output space-delimited file with quotes around text?
I need to output a file that has space-delimited fields, with quotes around
all text fields. For example, the following shows the output from Excel when Column A and Column B are both numbers, and Column C is text: 1234 5678 "Text" 42.9 36.78 "More Text" This is something that is very simple in OpenOffice, where it's possible to easily control delimiters, but I haven't been able to manage it in Excel without jumping through major hoops... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Output space-delimited file with quotes around text?
Sinc
Earl Kiosterud's free TEXTWRITE add-in should(will) do what you want. http://www.smokeylake.com/excel/text_write_program.htm Gord Dibben MS Excel MVP On Tue, 5 Dec 2006 14:39:00 -0800, Sinc wrote: I need to output a file that has space-delimited fields, with quotes around all text fields. For example, the following shows the output from Excel when Column A and Column B are both numbers, and Column C is text: 1234 5678 "Text" 42.9 36.78 "More Text" This is something that is very simple in OpenOffice, where it's possible to easily control delimiters, but I haven't been able to manage it in Excel without jumping through major hoops... Gord Dibben MS Excel MVP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need to export row as csv file with column e plus .bom as file name | Excel Discussion (Misc queries) | |||
| Conversion to Text file format error | Excel Discussion (Misc queries) | |||
| saving an excel file as text without text in quotes | Excel Discussion (Misc queries) | |||
| Exporting excel to text file | Excel Discussion (Misc queries) | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Linear Mode
