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 Deterministic 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.

Frequently Asked Questions

Does Excel support REGEXEXTRACT?

Google Sheets uses REGEXEXTRACT natively. Microsoft Excel 365 has added REGEXEXTRACT in newer builds; otherwise use TEXTSPLIT, MID/FIND patterns, or Power Query for extraction.

Why is my extracted email incomplete?

The pattern returns one match. For multiple emails in one cell, use repeated formulas, SPLIT/TEXTJOIN workflows, or Apps Script.

How do I extract email from text in Sheets?

Use REGEXEXTRACT with an email pattern on your cell (e.g. A2), or paste the exact formula from SheetMaster’s generator.

Related Formulas

CONCATENATETRIMUPPERLOWERPROPER

Want to become an Excel Pro?

Stop searching for formulas. Master Excel in 30 days with this top-rated course.

Learn More