Replaces part of a text string with a different text string using regular expressions.
REGEXREPLACE("Spreadsheets", "S.*d", "Bed")
REGEXREPLACE(text, regular_expression, replacement)
text- The text, a part of which will be replaced.
regular_expression- The regular expression. All matching instances in
textwill be replaced.
replacement- The text which will be inserted into the original text.
- Google products use RE2 for regular expressions. Google Sheets supports RE2 except Unicode character class matching. Learn more on how to use RE2 expressions.
- This function only works with text (not numbers) as input and returns text as output. If a number is desired as the output, try using the
VALUEfunction in conjunction with this function. If numbers are used as input, convert them to text using the
REGEXEXTRACT: Extracts the first matching substrings according to a regular expression.
REGEXMATCH: Whether a piece of text matches a regular expression.
SUBSTITUTE: Replaces existing text with new text in a string.
REPLACE: Replaces part of a text string with a different text string.