Forum Discussion

Dyon den Haan's avatar
Dyon den Haan
Copper Contributor
Apr 05, 2018
Solved

How to replace part of a formula?

Dear all,   Currently I would like to change part of a formula, because I use a new table of data for the new year 2018. Is it possible to easily replace this part of the formula instead of man...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Apr 05, 2018

    Hi Dyon,

     

    Ctrl+H and Replace all _2017 on _2018

Anonymous's avatar
Anonymous
Apr 05, 2018

Dyon,

If you want to make it future-proof, you may even replace it with =YEAR(TODAY())

You will avoid having the same problem next year as well. :)

Cheers.

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Apr 06, 2018

    I guess these are separate tables to be kept. Just 2018 is created by copying of 2017 and modifying the formula.

Resources