Converting cells to data file

[garyngkt]

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
:

 

[Dave Peterson]

Here are three sites that you could steal some code from:

Earl Kiosterud's Text Write program:
www.smokeylake.com/excel
(or directly: http://www.smokeylake.com/excel/text_write_program.htm)

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

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

(You may be happy with Earl's version--right out of the box!)