In this article, we will show you how to extract the domain from an email address in Excel. We will explore the Excel Formula to extract the domain from email address. Simply follow the steps below.
Follow the simple steps below to efficiently extract domain from an email address in Excel using a Formula.
Start by opening the Excel file that contains the email addresses. The email addresses should be listed in one column.
Choose a blank column where you want the extracted domains to appear. This column should be adjacent to the column with the email addresses.
In the first cell of your chosen blank column, enter the formula: =MID(A1, FIND("@", A1) + 1, LEN(A1) - FIND("@", A1)). Replace 'A1' with the cell reference of the first email address.
Click on the bottom-right corner of the cell with the formula and drag it down.
This action applies the formula to all email addresses in your list.
Finally, save your Excel file. Make sure all the extracted domains are correctly displayed next to their corresponding email addresses.
Follow the steps below to use Excel's 'Text to Columns' feature to easily separate the domain from email addresses.
Open the Excel file where the email addresses are listed. Ensure the email addresses are in a single column.
Click on the header of the column containing the email addresses to select it. Then, go to the Data tab on the ribbon and click on 'Text to Columns' to open the 'Convert Text to Columns Wizard'.
In the wizard, select 'Delimited' and click 'Next'.
Uncheck all pre-selected delimiters and check 'Other', typing an '@' symbol in the adjacent box. Click 'Next' again.
Choose the destination cell for the split data to begin. Click 'Finish'.
The domain part of the email addresses will be separated into a new column.
Save your Excel file with the newly extracted domain names next to the original email addresses.
We hope that you now have a better understanding of how to extract the domain from an Email address in Excel. If you enjoyed this article, you might also like our article on how to extract email addresses from Excel or our article on how to extract names from email addresses in Excel.
