I want to save an Excel file in "Pipe Delimited" (instead of csv).

[Guest]

I want to save my Excel file as "Pipe Delimited" (instead of csv) or else, if
csv, then all values from a column to be enclosed in double quotes and not
just the ones which have a comma in their values.

 

[Chip Pearson]

See www.cpearson.com/excel/imptext.htm for details and example
code.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Guest]

Thanks a lot Chip.

See www.cpearson.com/excel/imptext.htm for details and example
code.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Dave Peterson]

Another option...

Earl Kiosterud's Text Write program does this after you choose a couple of
options (if I recall correctly).

You can find it at:

www.smokeylake.com/excel
(or directly: http://www.smokeylake.com/excel/text_write_program.htm)