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