To get the domain from the email address we will use the RIGHT Function, LEN Function, and FIND Function.

Let’s get started:

domain from email address

As you can see in the image above, we have taken email address. To get the email domain out of email address, we only require email address so we do not need the name of the email holder or etc.

Previously: How to sum data by weekday in excel?

domain from email address

The first thing we will do is begin with the RIGHT Function, i.e. =RIGHT(

The following formula requires text as well as number characters.

domain from email address

Our text is the email address we have. So, we will select the same, in the above example it is dumdum@gmail.com or in other words, cell C3.

domain from email address

Then for the purpose of number characters we will use the LEN Function i.e. =LEN(

The following formula requires text.

domain from email address

The text is the email address only, so we will select the same (cell C3).

domain from email address

Then we will close the LEN Function and continue with the number characters only as it isn’t over yet.

domain from email address

Then we will add the negative sign as we will be using subtraction between the LEN and FIND Function.

So, input the minus sign.

domain from email address

Then we will come to the aspect of FIND Function, which includes find text, within text and star number (which is optional).

domain from email address

The find text will be our @ sign as we our looking for what’s on the right side of the same. But do not forget to write the same quotation marks.

So, it becomes “@”.

domain from email address

Now we come to within text, as we are looking for what is on the right side of the email address so our within text becomes the email address i.e. cell C3.

domain from email address

As the start number is optional so we will ignore the same. Now, all we have to do is close the FIND Function and then close the RIGHT Function.

So, overall our function becomes as follows:

=RIGHT(C3,LEN(C3)-FIND(“@”,C3))

domain from email address

Now all we have to do is hit “enter”.

And BAAAAMMMM!!! Here comes our answer gmail.com

domain from email address

Now all you have to is drag down the function so that you get the answers for all the email addresses.

You must be thinking that inputting such a huge formula is a head ache, but when you have loads of data entries then it is the most easiest way of all, because in real all you have to do is input the formula for one email address, later you have to drag down the same as shown in the image above, and your work is done!

domain from email address

It’s easy, isn’t is?