ExcelHeroThe FIND function
Returns the position of one text inside another.
In German Excel: FINDEN
How to write it
=FIND(find_text, within_text, [start_num])- find_text
- What to look for, like "@".
- within_text
- Where to look.
- start_num
- Optional. Where to start looking.
💡 FIND is case-sensitive. SEARCH is not.
Try it
Get the username: everything before the @ in Lena’s email.
A
B
C
D
1
Name
Email
Plan
Username
2
Lena
Pro
3
Tom
Free
4
Ivy
Free
5
Max
Pro
6
Zoe
Free
FIND("@",B2) gives the position of @. Take one less from the left.