Find Exact Digit in Formula

[Steve 1962]

Hi

I am trying to use FIND & REPLACE to change many formulas. Example -

I want to change the cell reference C4:C49 to show C3:C49 and Z4:Z49 to show Z3:Z49, etc. However, when I use FIND & REPLACE to change the row reference from 4 to 3, it also changes 49 to 39 (obviously only looking at the one digit which is the 3).

How do I stop it from changing the 2 x digit numbers also ?

The above example is only one cell but I am needing to change multiple cells and its not as simple as just copying across.

Thanks

 

[kevin9999]

Have you tried changing 4: to 3: ?

 

[Steve 1962]

Hey thanks Kevin. I didn't think about the colon.

Works fine. Have a good day.

 

[kevin9999]

You're welcome Steve and thanks for the feedback.