Formula Library
FIND
textReturns the position (character number) of a text string within another text string. Case-sensitive.
Syntax
=FIND(find_text, within_text, [start_num])Example
Excel
=FIND("@", A2)Returns the position of the "@" character in A2 (useful for parsing email addresses).
Tips & Notes
- →Returns #VALUE! if text is not found
- →SEARCH is the case-insensitive version
- →Use with LEFT/MID/RIGHT to extract text
See Also
Need a custom FIND formula?
Describe exactly what you need and get the formula generated instantly.