Replaces part of a string using regular expressions.
- 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.
REGEXREPLACE("Forehead","head","front") returns "Forefront".
- This function only works with text as input and returns text as output.