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 wrote in message
...
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 wrote in message
...
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.