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

[Guest]

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.

 

[Peo Sjoblom]

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)

 

[Earl Kiosterud]

Mohsin,

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