Functions
REGEXREPLACE
Replace regex matches in text
Try it
When to use it
When should I use REGEXREPLACE instead of SUBSTITUTE?
Use REGEXREPLACE when the text you want to replace follows a pattern rather than a fixed string, such as removing all punctuation or normalizing whitespace.
Used in
Syntax
REGEXREPLACE(text, pattern, replacement)