FIND Function in Excel | Advance Excel Course

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.


=FIND(find_text, within_text, [start_num])


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 defaults 1.

Example :

More Example : 

=FIND("p","apple") // returns 2

=FIND("z","apple") // returns #VALUE!


=FIND("a","Apple") // returns #VALUE!

=FIND("A","Apple") // returns 1