When click FILE in the menu and selects SAVE AS, one of the options in the
SAVE AS TYPE combo box is "CSV (Comman Delimited)(*.CSV)".

This option will do exactly what you're wanting to do.

--
Kevin Backmann


"Venkatesh V" wrote:

HI,
Creation of CSV file is simple.
Just 'Save As.." the excel file and it will be saved as a '|' separated.

But, how to create a '|' separated file?

Note: I wouldnt like to create csv and then replace all commas ',' with '|'.
This is because in between the text there may be some commas.


Thanks a Lot,
Venk