Steve 1962
Active Member
- Joined
- Jan 3, 2006
- Messages
- 349
- Office Version
- 365
- Platform
- Windows
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
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