Ok, I found it here.

http://www.smokeylake.com/excel/text_write_program.htm

Still not 100%, but better than what Microsoft can do on it's own ;-)

Pete

"Total Hosting 1" wrote:

Does any know of any means to change the delimiter when saving as text? I
want to use | (pipes) instead of TAB or CSV. I also want to get rid of
quotes.

I really wish Excel would behave like Access in this regard. Anyone?

Thanks

Pete