Change formula to Indirect
I need to change a lot of formulas to "Indirect".
Example, A1, =B1 - Need to change it to =Indirect("B1")
I have been trying find and replace;
Find =, Replace XIndirect("
This produces XIndirect("B1
How can I Find the end of formula and add, ")
Any ideas on how to add to the end of the formula or any other way of
changing a formula to indirect would be appreciated.
|