Summary

T extract the domain from an email address, you can use a formula based on the RIGHT, LEN, and FIND functions. In the generic form above, email represents the email address you are working with. In the example shown, the formula in E4 is:

=RIGHT(C4,LEN(C4)-FIND("@",C4))

Generic formula

=RIGHT(email,LEN(email)-FIND("@",email))

Explanation 

At the core, this formula extracts characters from the right with the RIGHT function, using FIND and LEN to figure out how many characters to extract. C4 contains the text "achang@maaker.com", so LEN returns 17 characters:

LEN(C4) // returns 17

FIND locates the "@" character inside the email address "achang@maaker.com". The "@" character is the 7th character, so FIND returns 7:

FIND("@",C4) // returns 7

The number 7 is then subtracted from the 17, which is 10. The number 10 is used as the second argument for the RIGHT function, which extracts 10 characters from the email address, starting from the right. The complete formula is evaluated and solved like this:

=RIGHT(C4,LEN(C4)-FIND("@",C4))
=RIGHT(C4,17-7)
=RIGHT("achang@maaker.com",10)
="maaker.com"
Dave Bruns Profile Picture

AuthorMicrosoft Most Valuable Professional Award

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.