pipe delimited format

[rick]

how do i save a spreadsheet in pipe delimited format?

i am using excel 2002, thanks

 

[Dan E]

Here's one way, works well if you only need to do it a couple of times!

Save as a csv.
change the extension of the csv to txt
open the file, select all and copy
paste it into word
use replace to replace "," with "|"
select all, copy and paste back into the text file

If you have to do it numerous times your best bet is a macro, post back if that's what you need

Dan E

 

[Dave Peterson]

Another option is to change your windows regional settings.

Windows Start button|settings|control Panel|Regional Settings applet
Number Tab|List separator|(change it to |)

Remember to change it back. It's a windows setting and may affect other
programs.

(Gotta go change mine back.)