Article updated on February 07, 2018

The FIND function returns the position of a specific string in another string, reading left to right. Note, the FIND function is case-sensitive.

Formula in cell C3:

=FIND(C3,B3)

The formula returns 7 , "friend" is found at character number 7 in text string "Hello friend".

Excel Function Syntax

FIND(find_text,within_text, [start_num])

Arguments

find_text Required. Is the text you want to find. ? and * wildcard characters are allowed.
within_text Required. This argument is the text in which you want to search for.
[start_num] Optional. The character number in within_text, counting from the left at which you want to start searching. If omitted 1 is used.

Comments

If the text string is not found the FIND function returns a #VALUE! error.

To avoid the error use the ISNUMBER function to make the function return TRUE or FALSE, like this:

=ISNUMBER(FIND(C3,B3))