Extract the Domain from an Email Address

Excel & Google Sheets

How it works

FIND locates the position of the @ sign, and MID returns everything starting one character after it — the +1 skips the @ itself, and 100 just means "take up to 100 characters," which is longer than any real domain. Because every valid email has exactly one @, this is one of the most reliable text extractions there is, and it works identically in Excel and Google Sheets. In Excel 365 you can also write =TEXTAFTER(A2,"@") for the same result.

FIND("@",A2)

Finds the position of the @ — in "ana@acme.com" that's 4.

+1

Steps past the @ so it isn't included in the result.

MID(A2, …, 100)

Returns up to 100 characters from that point: "acme.com".

When to use it

Use this to segment a signup list by company, filter out free-mail domains like gmail.com from a lead list, or build a domain column you can point COUNTIF at to see contacts per organization.

Common mistakes

• ✕Cells without an @ return #VALUE!.

  ✓FIND errors when the @ is missing — a blank cell or a name typed where an email should be. Guard it: =IFERROR(MID(A2,FIND("@",A2)+1,100),"").

• ✕Trailing spaces sneak into the domain.

  ✓"ana@acme.com " keeps its invisible space, so acme.com won't match acme.com elsewhere. Wrap the source: =MID(TRIM(A2),FIND("@",TRIM(A2))+1,100).