Extracting domain names from email addresses is a common task in data processing. By isolating the domain part of an email address, businesses can analyze and categorize email data more effectively. Excel provides powerful functions like FIND and MID to accomplish this task.
Extract Domain Names from a List of Email Addresses Using FIND and MID
The FIND function locates the position of a character or substring within a text string, while the MID function extracts a specific number of characters from a text string starting at a specified position. These functions can be combined to extract domain names from email addresses.
Example
Below is an example dataset showing email addresses. This dataset will be used to demonstrate how to extract domain names using FIND and MID functions.
| Email Address | Domain Name |
|---|---|
| [email protected] | example.com |
| [email protected] | sample.org |
Exercise
Extract the domain names from the following email addresses using FIND and MID functions:
Use the functions to extract the domain part of each email address.
Solution
To extract the domain names, follow these steps:
Domain Name: Use the FIND and MID functions to extract the domain name.
=MID(A2, FIND("@", A2) + 1, LEN(A2) - FIND("@", A2))
=MID(A3, FIND("@", A3) + 1, LEN(A3) - FIND("@", A3))