Find and Replace Formulas
I have a simple formula that I only want to find replace one mathematical sign. I have many cells with the original formula and multiple s. I tried using the * in place of the cell name and it did okay finding the formula but it would not replace the formula using the *. Is there a way to do this or do I have to do the copy and paste the new formula in several columns, several worksheet
from
A1+B1-C1 to A1-B1-C1
A2+B2-C2 TO A2-B2-C2
and so on
I have a simple formula that I only want to find replace one mathematical sign. I have many cells with the original formula and multiple s. I tried using the * in place of the cell name and it did okay finding the formula but it would not replace the formula using the *. Is there a way to do this or do I have to do the copy and paste the new formula in several columns, several worksheet fromA1+B1-C1 to A1-B1-C1A2+B2-C2 TO A2-B2-C2 and so on Read More