How to Extract Email Addresses from Text in Excel
Pull clean email addresses out of messy cells — signatures, notes, pasted lists — into their own column.
Last updated: August 2026
| Cell text | ||
|---|---|---|
| Contact Ana at ana@acme.com today | → | ana@acme.com |
| bob@x.io / +973 3312 4567 | → | bob@x.io |
| no address in this row | → | (blank) |
Method 1 — Flash Fill (Excel 2013+)
- In the column next to your data, type the email from the first row by hand.
- Start typing the second, or just press Ctrl + E. Excel fills the rest by matching the pattern.
- Works well when every cell has the email in a similar spot — but it silently gives up (or guesses wrong) on irregular text, with no warning.
Method 2 — REGEXEXTRACT (Excel 365)
If your Excel has the newer regex functions, one formula does it:
=REGEXEXTRACT(A2, "[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,}")- Copy it down. It returns the first email in each cell, or an error where there's none — wrap in
IFERROR(…, "")to blank those.
On older Excel without REGEXEXTRACT, the formula route means a long, brittle MID/FIND/SUBSTITUTE chain.
The 1-click way — Tellsheet's Extract Emails & URLs
Select the column, click Extract Emails & URLs, and Tellsheet replaces each cell with just the email(s) it contains — pulling every match, not only the first, and joining them with a separator you choose. Switch to URLs mode to grab web addresses instead. Previewed, revertable, and nothing leaves your PC.
Frequently asked questions
Is there an Excel formula to extract an email address?
On Excel 365, REGEXEXTRACT with an email pattern works. On older versions there's no simple built-in — you'd chain MID/FIND/SUBSTITUTE, use Flash Fill, or use Tellsheet's Extract Emails & URLs.
How do I extract multiple emails from one cell?
Formulas and Flash Fill only capture the first cleanly. Tellsheet pulls every email in a cell and joins them with a separator you choose.
How do I pull out URLs instead?
The same Tellsheet tool has a URLs mode that extracts web addresses from text and trims any trailing sentence punctuation.
Related Excel guides
Extract emails in one click
Get Tellsheet and pull emails, URLs, numbers and more out of messy cells — with a preview before every change.
Get Tellsheet free See pricing