REGEXREPLACE

Returns the string after replacing a part with a different text string using regular expressions.

Usage examples 

REGEXREPLACE("hello 124 134", "\d+", "world")

Syntax 

REGEXREPLACE ( value, regex, replacement )

• value - any string expression.

• regex - any string expression representing the regular expression. All matching instances in text will be replaced.

• replacement - any string expression representing the text which will be inserted into the original text.

Returns 

string - the string after replacing matching parts.

Functions reference