0

There is a formula:

SUM(GETPIVOTDATA("Water",'Pivot'!$A$3,"cCode",A2),GETPIVOTDATA("Water",'Pivot'!$A$3,"cCode",A2))

and the content of the formula doesn't matter. I would like to replace all instances of GETPIVOTDATA("Water") with GETPIVOTDATA("Soft-Drink") using regular expression.

aturan23
  • 4,798
  • 4
  • 28
  • 52
Fighter Jet
  • 407
  • 1
  • 5
  • 19
  • You should just use `Find & Replace` and look inside formulas (which will also work on a range object larger than a single cell). No need for regular expressions. – JvdV Mar 24 '20 at 09:01
  • No, I need to do it with Reg Exp. – Fighter Jet Mar 24 '20 at 09:09

0 Answers0