CODEWITHSUNDEEP
excel
osomanden
osomanden

Reputation: 611

excel replace string in formula

Using Excel 2010, I have a sheet filled with "almost" the same formula. I need to replace all instances from =COUNTIFS to =1-(COUNTIFS and then the last ) needs replaced with ))

Trying to use CTRL+H gives errors that the formula is missing a )

Anyother smart way to get this done?

Upvotes: 0

Views: 172

Answers (1)

ttaaoossuu
ttaaoossuu

Reputation: 7884

There's a way if you're using Excel 2013 or newer.

  1. Use FORMULATEXT() function to modify your formulae, like this: ="1-("&FORMULATEXT(A1)&")".
  2. Copy and paste the results of this as values.
  3. Now you have correct formulae as text. To force their evaluation simply select them and replace (Ctrl+H) = for =. This way formulae are not changed but forced to re-evaluate.

Upvotes: 1

Related Questions