Excel help - Advanced find and replace

Soldato
Joined
10 Apr 2004
Posts
13,497
I currently have a formula like this:

Code:
('Stage 1 T-O'!$AA*9.81-X2)

I need it to look like this:

Code:
(('Stage 1 T-O'!$AA-(X2*0.45359237))*9.81)

However, X2 is a changing row number from X2 onwards.

How do I get excel to find each incorrect line (regardless of the row number after the X) to the correct formula along with the correct row number?

So:
Code:
('Stage 1 T-O'!$AA*9.81-X999)
goes to
Code:
(('Stage 1 T-O'!$AA-(X999*0.45359237))*9.81)

Cheers!
 
Back
Top Bottom