How to replace parts of formula in excel?

Ivan Petrov 0
Viewed 15

  1. I have in first column this:

    =SUM('\Y2022[Salaries_combined_01.2021-08.2022.xlsx]report'!$ND$353:$NG$353)

  2. In the second column the formula should look like this

    =SUM('\Y2022[Salaries_combined_01.2021-08.2022.xlsx]report'!$NV$353:$NY$353)

  3. How to replace only columns "ND" -> "NV" and "NG" -> "NY" at once, automatically and not by hand with (Ctrl + H)?

excel
1 Answers

A technique I use is to do the following:

  1. select column or range and replace "=" with xyxyxy

  2. edit replace "ND" with "NV", repeat for "NG" "NY"

  3. then replace xyxyxy with =

Works well as each change does not cause errors as removing the = makes all the cell entries text...

Solar Mike0
Related