Extract Email Address from Text
Extracts an email address from a text string.
=REGEXEXTRACT(A2, "[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,}")Learning Resources
Want to master Excel? Check out this Top-Rated Course.
How to Extract Email from Text in Google Sheets
Cleaning messy data is one of the most time-consuming tasks in spreadsheet management. If you have a column of raw text, such as CRM exports or scraped web data, our AI-powered Email Extractor generates the exact REGEXEXTRACT formula you need to automate this process.
Understanding the Formula Logic
The core of this tool relies on Regular Expressions (Regex). The standard formula follows this pattern: =REGEXEXTRACT(A2, "[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,}")
Alternative: Excel vs Google Sheets
While Google Sheets natively supports REGEX, Excel traditionally requires complex combinations of LEFT, MID, and FIND. This generator ensures you get the most compatible string for your platform.
Pro Tip: To extract multiple emails from a single cell, you might need a custom Apps Script or a combination of TEXTJOIN and REGEXREPLACE.
Want to become an Excel Pro?
Stop searching for formulas. Master Excel in 30 days with this top-rated course.
Learn More