FIND

Explanation

FIND function lets us find the position of a text within another text/cell. 

Note that FIND is case-sensitive, meaning that if you try to find “GOAT” within “goat cheese”, the function will break. In case you are looking for a case-insensitive alternative, use the SEARCH function instead. 

Syntax

=FIND(find_text, within_text, [start_num])

find_text – The text for which we’d like to find the position in the second text.

within_text – In which text we are looking for the “find_text”. Within_text can be either a simple text string or a reference to a cell. 

[start_num] – Optional. In case you want to start the lookup from a specific position in text, you can type the start number here. If not used, the default is starting from the beginning of the text/cell.

Example

Practice FIND function