Thanks Dave. I actually found your post from February after doing more
research and it worked great. Thanks again.

"Dave Peterson" wrote:

One way is to change that list separator.

Under the Regional settings Applet under Windows control panel.

In winXP, you can click on the Advanced button on the "regional options" tab.

Then on the numbers tab, change the list separator character.

Remember to change it back when you're done. It's a windows setting and affects
other programs.

Another option is to write a macro that does exactly what you want.

Some sample code to get you started:

Earl Kiosterud's Text Write program:
www.smokeylake.com/excel
(or directly: http://www.smokeylake.com/excel/text_write_program.htm)

Chip Pearson's:
http://www.cpearson.com/excel/imptext.htm

J.E. McGimpsey's:
http://www.mcgimpsey.com/excel/textfiles.html

(Earl's code may do what you want right out of the box.)

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm


Sarah wrote:

Can anyone tell me if it's possible to save an Excel spreadsheet as a pipe
delimiter instead of a tab or comma separated?

--

Dave Peterson