Problem:

Question: Can anyone explain if it's possible to create a function to change a formula with the following idea.

for example:

You have a complex formula and want to change the "= formula" by "=(formula)" so at front and at the back I want to add a "(" and a ")".

Because manually changing is a lot of work for lets say 1000 cells, is there a possibility to do that with a macro or is there already a button or short-key in Excel that does it.

Please explain in detail how to create a function to change a formula.