Replaces part of a text string with a different text string using regular expressions.
Sample usage
REGEXREPLACE("Spreadsheets", "S.*d", "Bed")
Syntax
REGEXREPLACE(text, regular_expression, replacement)
-
text
– The text, a part of which will be replaced. -
regular_expression
– The regular expression. All matching instances intext
will be replaced. -
replacement
– The text that will be inserted into the original text.
Notes
- 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
VALUE
function in conjunction with this function. If numbers are used as input, convert them to text using theTEXT
function.
See also
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.