Excel Formulas to Get Domain from Email Address ~ Quickly!!
Tags: excelformula, excelformulas
Published: 2021-07-03 03:33:37

---
title: Excel Formulas to Get Domain from Email Address ~ Quickly!!
published: true
date: 2021-06-28 12:10:14 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-get-domain-from-email-address/
---

If you have a list of customer email addresses in your worksheet, and now you want to extract their domain names from the cells separately. How could you quickly deal with this problem in Excel? Here we are going to see the formulas to **extract the domain name from the email address in Excel**. Let’s dive into this article!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Get domain from email](https://geekexcel.com/wp-content/uploads/2021/06/Get-domain-from-email.png)](https://geekexcel.com/excel-formulas-to-get-domain-from-email-address/get-domain-from-email/#main)<figcaption id="caption-attachment-48074">Get a domain from email</figcaption>

## Generic Formula:

- If you want to extract the domain name from the email address, you can use the below formula.

**=[RIGHT](https://geekexcel.com/how-to-use-right-function-in-microsoft-excel-365/)(email,[LEN](https://geekexcel.com/how-to-use-len-function-in-microsoft-excel-365/)(email)-[FIND](https://geekexcel.com/how-to-use-find-function-in-microsoft-excel-365/)(“@”,email))**

## Syntax Explanations:

- **RIGHT** – In Excel, the [**RIGHT function**](https://geekexcel.com/how-to-use-right-function-in-microsoft-excel-365/) helps to extract the characters from the right side of a text string.
- **LEN** – This function helps to return the length of a given text string as the number of characters. Read more on the **[LEN function](https://geekexcel.com/how-to-use-len-function-in-microsoft-excel-365/)**.
- **FIND** – The **[FIND function](https://geekexcel.com/how-to-use-find-function-in-microsoft-excel-365/)** will find out the one text string inside the other.
- **Email** – It represents the email address of the user.
- **Minus Operator (-)** – This symbol will help to subtract any two values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Practical Example:

Let’s consider the below example image.

- First, we will enter the email addresses in **Column B**.
- Here we need to extract the domain name from the email address.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/06/Input-Ranges-80.png)<figcaption id="caption-attachment-48075">Input Ranges</figcaption>

- Select any cell and type the above-given formula.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/06/Enter-the-formula-95.png)<figcaption id="caption-attachment-48077">Enter the formula</figcaption>

- Finally, press the ** ENTER**  key, you can get the result as shown below.

![Result](https://geekexcel.com/wp-content/uploads/2021/06/Result-80.png)<figcaption id="caption-attachment-48076">Result</figcaption>

## Conclusion:

Hope you like this article on how to **get the domain name from the email address in Excel**. If you have any other **ideas** or **questions** , share them with us here in the **comments** section below.

Thank you so much for visiting  **[Geek Excel](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Read Ahead:

- **[Excel Formulas to Create Email Address with Name and Domain!!](https://geekexcel.com/excel-formulas-to-create-email-address-with-name-and-domain/)**
- **[How to Insert a Date or Formatted Date in Excel Office 365?](https://geekexcel.com/how-to-insert-a-date-or-formatted-date-in-excel-office-365/)**
- **[Excel Formulas to Calculate the Area of a Circle ~ Simple Tutorial!!](https://geekexcel.com/excel-formulas-to-calculate-the-area-of-a-circle-simple-tutorial/)**
- **[Excel Formulas to Calculate Total Income Tax with Multiple Tax Brackets!!](https://geekexcel.com/excel-formulas-to-calculate-total-income-tax-with-multiple-tax-brackets/)**