How to Use REGEXREPLACE() in Google Sheets

Description

Replaces part of a text string with a different text string using regular expressions.

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.

Your formula

Hints (3)

Locale Separator ,

Official Docs

Better Sheets Tutorial

Take a list and make it Vertical, Using Split Join or RegexReplace

Create vertical lists in Google Sheets.

Beginner

JOIN() REGEXREPLACE() SPLIT() TRUE()

Transcript-matched member videos for REGEXREPLACE(). Click through to watch.

Watch more tutorials

REGEXMATCH Formula Generator for Google Sheets

Revolutionize the way you handle data with the BetterSheets REGEXMATCHER...

Advanced

IF() REGEXMATCH()

200 REGEXMATCH Examples in Google Sheets

Uncover the Magic of Regex Match! 🎩✨ Explore 200+ Examples at BetterShee...

Conditional Formatting Data validation Advanced

IF() REGEXEXTRACT() REGEXMATCH()

Currency Exchange Tricks In Google Sheets

Little tricks to make Currency Exchange in Google Sheets better for you,...

Advanced Intermediate Beginner

GOOGLEFINANCE()

Calculate ROAS in Google Sheets

Calculate Return on Ad Spend with a formula combination. Bonus: create a...

Intermediate

CONCATENATE() ROUND()

Unlock these tutorials

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