Formulas > =REGEXEXTRACT()
How to Use REGEXEXTRACT() in Google Sheets
Description
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.
Hints (3)
-
Remember to use the '@' symbol in your regular expression.
-
You need to capture everything after the '@' symbol.
-
Make sure to apply the formula to the entire range B1:B10.
1 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.
Use REGEXMATCHER to generate any REGEXTMATCH formula you want.
IF()
REGEXEXTRACT()
REGEXMATCH()
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