Hi Friends,
I have an excel sheet which I need to store as a pipe delimited text file.
This should be done using macro.
For example:
input:

45 56 78 abcd

output:

45|56|78|abcd|

I cannot create a tab delimited or csv file and then replace manually. It has to be done automatically.

Please Help!!