Replaces part of a string using regular expressions.
Sample Usage
REGEXREPLACE("Forehead","head","front")
REGEXREPLACE(A1,A2,A3)
Syntax
REGEXREPLACE(text,regular_expression,replacement)
- text - The text, a part of which will be replaced.
- regular_expression - The regular expression.
- replacement - The text which will be inserted into the original text.
Examples
REGEXREPLACE("Forehead","head","front") returns "Forefront".
Notes
- This function only works with text as input and returns text as output.