How to create a function to change a formula


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.

Request for Solution File

Ask an Expert for Answer!!
Computer Engineering: How to create a function to change a formula
Reference No:- TGS0892770

Expected delivery within 24 Hours