View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Venkatesh V
 
Posts: n/a
Default How to create '|' separated file

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