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...
|