Formulas > =REGEXREPLACE()
How To Use REGEXREPLACE() Function in Google Sheets
Description
How To Actually Use REGEXREPLACE() in Sheets
REGEXREPLACE(text, regular_expression, replacement)
Try REGEXREPLACE yourself
In cells A1:A10, you have various text strings. Use the REGEXREPLACE formula to replace all occurrences of 'cat' with 'dog' in this range, and place your results in cells B1:B10.
Hints (3)
-
Remember to reference the correct cell in your formula.
-
Use double quotes for the text strings in the formula.
-
Make sure to drag the formula down to fill cells B1:B10.
1 Better Sheets Tutorial
Take a list and make it Vertical, Using Split Join or RegexReplace
Create vertical lists in Google Sheets.
JOIN()
REGEXREPLACE()
SPLIT()
TRUE()
Learn more about the REGEXREPLACE() formula:
Generate a REGEXREPLACE() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses REGEXREPLACE(). 2 free AI generations, no signup. Members get unlimited use.
Generate a REGEXREPLACE() formula