**Are you looking for a way to extract the domain names from a list of email addresses in Excel? In this tutorial, we will walk you through the steps of using three Excel formulas – RIGHT, LEN, and FIND – to accomplish this task.**

## Step-by-Step Instructions

- Start by using the
**RIGHT**formula. The syntax for this formula is =**RIGHT(text, number of characters)**. The “**text**” argument should be the cell containing the email address, and the “**number of characters**” argument should be the**number of characters you want to extract**from the right side of the email address. - Next, we need to determine the number of characters to extract. To do this, we will use the
**LEN**formula. The syntax for this formula is =**LEN(text**). The “text” argument should be the**cell containing the email address**. - Now we need to subtract all the values before the domain name from the total number of characters. To do this, we will use the
**FIND**formula. The syntax for this formula is =**FIND(find text, within text).**The “**find text**” argument should be the**@,**and the “**within text**” argument should be the**cell containing the email address**. - Finally, we will combine these three formulas in the following format:
**=RIGHT(cell with email address, LEN(cell with email address)-FIND(“@”, cell with email address))**. This formula will extract the desired number of characters from the right side of the email address, starting with the domain name. - To apply this formula to the rest of the cells in your sheet, simply drag the cell with the formula down. Done!

## Conclusion

By using the RIGHT, LEN, and FIND formulas, you can easily extract domain names from a list of email addresses in Excel. This can be a useful tool for analyzing and organizing your data by domain name.