How do I fix misspelled email domains like gmial.com?

Formulas can patch known typos with nested SUBSTITUTE, but it's tedious. Clean Email Addresses corrects common misspellings of popular domains (gmial, hotmial, yaho, outlok) automatically.

How do I find invalid email addresses in Excel?

A rough check is that the cell contains one @ and a dot after it. Clean Email Addresses reports how many entries still don't look valid after cleaning, and Validate Data can flag each invalid row against an email rule.

Home › Excel Guides › Clean a List of Email Addresses in Excel

How to Clean a List of Email Addresses in Excel

A list of emails from a form, a paste, or an export is never clean: stray spaces, mixed case, mailto: prefixes, <angle brackets>, and typos like gmial.com. Here's how to make it send-ready.

Last updated: August 2026

Messy		Clean
MAILTO:<[email protected]>	→	[email protected]
jane @ hotmial.com	→	[email protected]

Method 1 — TRIM, LOWER and SUBSTITUTE

=LOWER(TRIM(A2)) trims the ends and lowercases.
Wrap with SUBSTITUTE to strip "mailto:", <, > and internal spaces.
Copy and Paste Special > Values back over the list.

This handles the formatting, but it can't fix a misspelled domain, and it won't tell you which addresses are still broken. TRIM also leaves spaces in the middle of a value, so john @ example.com needs an extra SUBSTITUTE.

Method 2 — patch typos with nested SUBSTITUTE

To fix domains you'd nest calls like =SUBSTITUTE(SUBSTITUTE(A2,"gmial.com","gmail.com"),"hotmial.com","hotmail.com") — workable for two or three, unmanageable for a real typo list, and easy to get wrong.

The 1-click way — Tellsheet

Clean Email Addresses repairs a whole column at once: it trims spaces, strips mailto: and <angle brackets>, removes internal spaces, lowercases, and corrects common domain typos (gmial → gmail, hotmial → hotmail, yaho → yahoo, outlok → outlook). It then reports how many addresses still look invalid, so you know exactly what's left to check. Previews first and is revertable. Pairs with Validate Data and Extract Emails & URLs.

Frequently asked questions

How do I clean an email list in Excel?

TRIM + LOWER + SUBSTITUTE for the formatting, or Tellsheet's Clean Email Addresses for trimming, lowercasing, typo-fixing and invalid-flagging in one click.

How do I fix domains like gmial.com?

Clean Email Addresses corrects common misspellings of popular domains automatically.

How do I find invalid emails?

Clean Email Addresses counts how many still look invalid; Validate Data flags each invalid row.

Does TRIM remove spaces in the middle?

No — TRIM only trims the ends. Clean Email Addresses also removes spaces inside the address.

Related Excel guides

Make a dirty email list send-ready

Clean Email Addresses trims, lowercases, fixes typos, and flags invalids — right inside Excel.

Get Tellsheet free See pricing