View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sinc Sinc is offline
external usenet poster
 
Posts: 2
Default 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...