Text & Cleanup

Excel formula for Extract the domain from an email address

Pull the part after the @ out of an email address.

Copy this formula

=MID(A2, FIND("@", A2)+1, LEN(A2))

How the formula works

FIND locates the @ symbol, MID starts one character after it, and LEN as the length grabs the rest of the string. The result is the domain, e.g. example.com.

Examples

=MID("[email protected]", FIND("@", "[email protected]")+1, 99)→example.com

Returns everything after the @.

Other ways to do this

Get the name part

=LEFT(A2, FIND("@", A2)-1)

Returns the username before the @.

FAQ

What if some cells have no @?

Wrap in IFERROR to return blank: =IFERROR(MID(A2, FIND("@",A2)+1, 99), "").

Related formulas

Split text into separate columns Remove extra spaces from text

Functions used

MID FIND LEFT LEN

Need a formula for your own data?

Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.

Try ExcelGPT free