What is FIND?
Returns the starting position of one text string within another. Case-sensitive search essential for text parsing and extraction.
Syntax
=FIND(find_text, within_text, [start_num])
Example
Formula: =FIND(\
Result: 6
How It Works
Returns the position of '@' in the email address. If A1 is 'test@email.com', the @ is at position 5. Returns #VALUE! if not found.