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