Hi,
You could import the text file into excel, do your find
and replace (record a macro that does this) then save As a
text file.


Otherwise, you could use VB ie not excel. Look at my VB
site:
http://au.geocities.com/windsofmark for some sample
utilities.

I could modify one to do your task. Just send me the text
file

or


Regards
Mark E. Philpot

http://au.geocities.com/windsofmark
http://au.geocities.com/excelmarksway
Please allow 1 to 3 days for a result
(no fee required unless you want to)

-----Original Message-----
Hi

I have a file from one of our sub systems which I get
once
a month.

I need to do a Find and replace on this file for the
following parameters:

Find 002.306003001.4206 Change to 998.306003001.4206

Find 004.306003001.4206 Change to 999.306003001.4206

Find 002.010100001. Change to 998.010100001.

Find 004.010100001. Change to 999.010100001.

Find 002.306003001.4208 Change to 998.306003001.4208

Find 004.307002001.3411 Change to 999.307002001.3411


Also, if we can rename the file once this has completed.

Thanks
Nick
.