How do I export XLS to TXT delimited by '|'?

I am trying to export an excel document that I have created to a delimited
text file but it needs to be delimited by the character '|'. The only option
that I am getting is tab or comma delimited. Can anyone advise how I can do
either using Excel or is there a 3rd party software that can do this? All
help much appreciated.

http://www.mcgimpsey.com/excel/textfiles.html

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"Mohsin Ghani" <Mohsin [email protected]> wrote in message
news:[email protected]...
>I am trying to export an excel document that I have created to a delimited
> text file but it needs to be delimited by the character '|'. The only
> option
> that I am getting is tab or comma delimited. Can anyone advise how I can
> do
> either using Excel or is there a 3rd party software that can do this? All
> help much appreciated.

Mohsin,

If you don't want to use a macro, get the Text Write Program from
www.smokeylake.com/excel.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Mohsin Ghani" <Mohsin [email protected]> wrote in message
news:[email protected]...
>I am trying to export an excel document that I have created to a delimited
> text file but it needs to be delimited by the character '|'. The only
> option
> that I am getting is tab or comma delimited. Can anyone advise how I can
> do
> either using Excel or is there a 3rd party software that can do this? All
> help much appreciated.