Extract domain from email
IntermediateWhen you’re cleaning customer data, it’s common to segment leads by email domain (for example, grouping everyone from the same company).
In this sheet, column C contains customer email addresses. Your goal is to extract just the domain part (everything after the @) into column D.
You’ll build the result using three text functions:
- FIND: returns the position of a character (use it to locate @)
- LEN: returns the total number of characters in the email
- RIGHT: returns the last n characters from the email
Your task
- In cell D2, write a formula that returns the domain from the email in C2.
- Fill the formula down through D10 to extract the domain for every lead.
Make sure the result does not include the @ symbol.
Need some help?
Hint 1
First locate the @ symbol in the email, then extract everything to the right of it.
Hint 2
A common approach is to calculate the number of characters after @ as `LEN(email) - FIND("@", email)`.
Hint 3
Once you have the character count, use RIGHT to return that many characters from the email cell and fill down.
Answer
Exercise
Extract domain from email
IntermediateWhen you’re cleaning customer data, it’s common to segment leads by email domain (for example, grouping everyone from the same company).
In this sheet, column C contains customer email addresses. Your goal is to extract just the domain part (everything after the @) into column D.
You’ll build the result using three text functions:
- FIND: returns the position of a character (use it to locate @)
- LEN: returns the total number of characters in the email
- RIGHT: returns the last n characters from the email
Your task
- In cell D2, write a formula that returns the domain from the email in C2.
- Fill the formula down through D10 to extract the domain for every lead.
Make sure the result does not include the @ symbol.
Need some help?
Hint 1
First locate the @ symbol in the email, then extract everything to the right of it.
Hint 2
A common approach is to calculate the number of characters after @ as `LEN(email) - FIND("@", email)`.
Hint 3
Once you have the character count, use RIGHT to return that many characters from the email cell and fill down.