1 | text | regular_expression | replacement | Result | Formula | |
|---|---|---|---|---|---|---|
2 | Google Doc 101 | [0-9]+ | 777 | Google Doc 777 | =REGEXREPLACE(A2, "[0-9]+","777") | |
3 | The price is $826.25 | [0-9]*\.[0-9]+[0-9]+ | 315.75 | The price is $315.75 | = REGEXREPLACE(A3,"[0-9]*\.[0-9]+[0-9]+", "315.75") | |
4 | (Content) between brackets | \(([A-Za-z]+)\) | Word | Word between brackets | =REGEXREPLACE(A4, "\(([A-Za-z]+)\)", C4) | |
5 |