Intermediate
Text
FIND
Returns the position where one piece of text starts inside another, and is case-sensitive.
Compatibility: All Excel versions
Syntax
=FIND(find_text, within_text, [start_num])
Example
=FIND("@",A1)
When to Use It
Use FIND when case matters — e.g. finding the exact position of the @ symbol in an email address to split it into two parts.