REGEX_REPLACE

Returns a new string created by replacing all matches in the specified string using the regex and a replacement string.

Syntax

=REGEX_REPLACE(regex, string, replacement)

Argument	Type	Description
regex	String	The regex to use when looking for matches
string	String	The string to look for matches in
replacement	String	The string to replace all found matches with

=REGEX_REPLACE("b.?", "abc", "ZZZ")→"aZZZ"