Take the domain after the @
PremiumIn B2, get the domain, the part of the email in A2 after the @. Use MID to start one character after the @, and LEN for the number of characters.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Domain | |||||
| 2 | anna.berg@northwind.com | |||||
| 3 | ||||||
| 4 | ||||||
| 5 | ||||||
| 6 | ||||||
| 7 | ||||||
| 8 |
Premium lesson
Unlock FIND and SEARCH and every other lesson
This is a premium lesson. Premium lets you solve it and every other lesson, take the timed mock tests, and earn certificates you can share on LinkedIn.
Why this works
FIND("@",A2)+1 is 11, the first character after the @. LEN(A2) is the length of the whole address, 23, which is more than is left. That is fine: MID stops at the end of the text, so you get "northwind.com" without counting the domain's length.
Common mistake: Starting MID at FIND("@",A2), without +1. The domain then begins with the @.
The answer
- B2
=MID(1A2,2FIND("@",A2)+1,3LEN(A2))
In plain words: From 1the email in A2, take 3as many characters as the email is long, 2starting just after the @.