Find the @ in an email with FIND
Step 1 of 3
LEFT, RIGHT and MID need to know where to cut. In an email address the name before the @ can be any length, so you first have to find the @.
Click Continue when you're ready.
Already know it? Type the formula straight into B2.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Position of @ | |||||
| 2 | anna.berg@northwind.com | |||||
| 3 | ||||||
| 4 | ||||||
| 5 | ||||||
| 6 | ||||||
| 7 | ||||||
| 8 |
Need help?
Why this works
FIND("@",A2) reads A2 from the left and returns the position of the first @. "anna.berg" is 9 characters, so the @ is character 10. On its own a position is not much use, but the next lessons use it to cut the text in two.
Common mistake: Swapping the arguments. FIND takes what to look for first and the text to look in second.
The answer
- B2
=FIND(1"@",2A2)
In plain words: Find the position of 1the @ in 2the email in A2.
The position of the first match, counting from 1. If the text is not there, FIND returns #VALUE!.
+10 points