changing the delimiter while saving as txt file

[raj]

Dear Experts,

is there a way to change the delimiter to # instead of tab
characters while saving the excel file to .txt file.

Thanks in advance

 

[Frank Kabel]

Hi
see:
http://www.cpearson.com/excel/imptext.htm

 

[Dave Peterson]

And some more links...

Maybe you can steal some code and create your own macro that does it:

Earl Kiosterud's Text Write program:
http://www.tushar-mehta.com/
Look for Text Write in the left hand frame.

Chip Pearson's:
http://www.cpearson.com/excel/imptext.htm

J.E. McGimpsey's:
http://www.mcgimpsey.com/excel/textfiles.html

Earl's may be ready as-is.