How to Use REGEXEXTRACT() in Google Sheets

Description

Extracts matching substrings according to a regular expression.

How To Actually Use REGEXEXTRACT() in Sheets

REGEXEXTRACT(text, regular_expression)

Try REGEXEXTRACT yourself

In cells A1:A10, you have a list of email addresses. Use REGEXEXTRACT to extract the domain (the part after the '@') from each email address and place the results in cells B1:B10.

Your formula

Hints (3)

Locale Separator ,

Official Docs

Better Sheets Tutorial

200 REGEXMATCH Examples in Google Sheets

Uncover the Magic of Regex Match! 🎩✨ Explore 200+ Examples at BetterSheets.co. Validate emails, detect hashtags, format data & more! Dive into the world of Regular Expressions. Start Your Regex Journey Now!

Use REGEXMATCHER to generate any REGEXTMATCH formula you want.

Conditional Formatting Data validation Advanced

IF() REGEXEXTRACT() REGEXMATCH()

Transcript-matched member videos for REGEXEXTRACT(). 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()

Calculate ROAS in Google Sheets

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

Intermediate

CONCATENATE() ROUND()

Embed a Number in a Website from a Google Sheet

Ever wanted to display some data from a google sheet on your site? Witho...

Advanced

Currency Exchange Tricks In Google Sheets

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

Advanced Intermediate Beginner

GOOGLEFINANCE()

Unlock these tutorials

Learn more about the REGEXEXTRACT() formula:

Generate a REGEXEXTRACT() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses REGEXEXTRACT(). 2 free AI generations, no signup. Members get unlimited use.

Generate a REGEXEXTRACT() formula