Want to save Excel Workbook as Pipe Delimited 1

[Nunina]

I need to save an Excel Workbook as a Pipe Delimited file, but the only options I can find are the ones that Excel gives for saving the data.

Any suggestions?

Thanks,

Nunina

 

[mikevh]

Save it as a tab-delimited (.txt) file.
Open it in Word and replace the tabs with |'s.
(When you have the Replace dialog open in Word,
click More > Special and you'll see Tab listed
as one of the special chars you can replace.)