How to Extract an Email Address from Text in an Excel or Sheets Cell

To extract an email address from text in a cell, use =REGEXEXTRACT(A2,"[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,}") in Google Sheets or Microsoft 365. Or paste the column into the extract email from a cell tool and get one clean, lower-cased address per row to paste back, plus the formula for your spreadsheet version.

It finds text shaped like an address. It does not check that the address works.

Why addresses end up mixed with other text

Exports from CRMs, forms and mail clients often put the address inside a name, a note, brackets or a mailto link: Jane Doe <jane@example.com>. Verifying or importing those cells directly fails, so you need the bare address in its own column first.

The by-hand way

1. In Google Sheets or Microsoft 365, put the REGEXEXTRACT formula above in the next column and fill it down.
2. In older Excel, use a longer text formula that finds the @ and trims to the surrounding spaces, brackets and commas.
3. Check rows that return an error, since they usually have no address.
4. Copy the new column and paste it as values.

Older Excel formulas are long and easy to get wrong, and brackets and commas are the usual culprits.

Step 1: copy the column

Copy the column in Excel or Google Sheets, from the first row you want to the last.

Step 2: paste and choose

Paste it into the tool and choose the first address per cell or every address in it.

Step 3: extract and paste back

Press Extract. Each row gets its address; rows without one stay blank so nothing shifts. Copy the column back next to the original, or copy the formula for your version.

For checking addresses inside Excel, see verify emails in Excel. To pull addresses out of a long text, use the email extractor.

What this check cannot do

• The pattern finds text shaped like an address. Unusual but valid addresses can be missed or cut.
• It does not check the domain or mailbox.
• Quoted local parts and other rarely used address forms are not handled.
• You review the output before replacing the original column.

For the same job on a whole file, see the CSV email column finder.

The step after this

Clean addresses in their own column are what a verifier needs. You can upload the file to the verify page and get the first 100 checks free after a Google sign-in, no card needed. Each address is marked valid, risky or invalid with a reason, and the check sends nothing to the people on it. List cleaning and bulk email verification cover regular or large jobs.

Try it now

Paste your column into the extract email from a cell tool.