Hi,

How do I convert certain cells in a excel sheet to data files which i
in tab delimited format or separated by pipe "|"?. I know that this ca
be done manually by copying the cells into a new sheet, then perform th
"Save As" function.

But is there a macro which can do this automatically?.

Here is an example of the section which I need to convert to a dat
file.

1 - 100,000.00 - -
2 - 100,000.00 - -
3 78.60 100,000.00 149.36 149.36
4 119.10 100,000.00 194.48 352.80
5 160.30 100,000.00 239.52 613.49
6 202.40 100,000.00 284.64 934.94

Thanks and appreciate your help.

Kind regards,
Gary Ng
:

--
garyngk
-----------------------------------------------------------------------
garyngkt's Profile: http://www.excelforum.com/member.php...fo&userid=1497
View this thread: http://www.excelforum.com/showthread.php?threadid=26599