FIND function in Excel returns the position (as a number) of
one text string inside another cell and when the text is not found, FIND function
returns a #VALUE error.
If there is more than one occurrence of the search string, FIND Function returns the position of the first occurrence by default.
Syntax
=FIND(find_text, within_text, [start_num])
Arguments
1. find_text - The substring to find.
2. within_text - The text to search within.
3. start_num - [optional] The starting position in the text to search.by defaults 1.
Example :
=FIND("p","apple") // returns 2
=FIND("z","apple") // returns #VALUE!
Case-sensitive
=FIND("a","Apple") // returns #VALUE!
=FIND("A","Apple") // returns 1