To get the domain from the email address we will use the RIGHT Function, LEN Function, and FIND Function.
Let’s get started:
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?
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.
Our text is the email address we have. So, we will select the same, in the above example it is firstname.lastname@example.org or in other words, cell C3.
Then for the purpose of number characters we will use the LEN Function i.e. =LEN(
The following formula requires text.
The text is the email address only, so we will select the same (cell C3).
Then we will close the LEN Function and continue with the number characters only as it isn’t over yet.
Then we will add the negative sign as we will be using subtraction between the LEN and FIND Function.
So, input the minus – sign.
Then we will come to the aspect of FIND Function, which includes find text, within text and star number (which is optional).
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 “@”.
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.
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:
Now all we have to do is hit “enter”.
And BAAAAMMMM!!! Here comes our answer gmail.com
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!
It’s easy, isn’t is?