Exceljet

Quick, clean, and to the point

Get domain from email address

Excel formula: Get domain from email address
Generic formula 
=RIGHT(email,LEN(email)-FIND("@",email))
Explanation 

If want to extract the domain from an email address, you can do so with a formula that uses the RIGHT, LEN, and FIND functions. In the generic form above, email represents the email address you are working with.

In the example, we are using this formula:

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

Here's how the formula works

C4 contains the email address "achang@maaker.com".

At the core, this formula is extracting characters starting from the right, and using the FIND and LEN functions to figure out how many characters to extract.

LEN computes the length of the entire email address, which 17 characters.

FIND locates the "@" character inside the email address "achang@maaker.com". The "@" character is the 7th character, so FIND 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 result is the domain, "maaker.com"

Altogether, this formula works something like this

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

Excel Formula Training

Formulas are the key to getting work done in Excel. In this step-by-step training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Start building valuable skills with Excel formulas today. Learn more.

I watched a few videos this morning and learned one key thing that will save me hours at work!
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Shortcuts Video Course
Excel Charts video training course