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.

Improve this question
2
  • 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. Commented Mar 24, 2020 at 9:01
  • No, I need to do it with Reg Exp. Commented Mar 24, 2020 at 9:09
Related questions
5466
Regular expression to match a line that doesn't contain a word
4306
How can I validate an email address using a regular expression?
1975
How do you use a variable in a regular expression?
Load 7 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.