FIND function
FIND locates a text string within another text string and returns the starting character position of the first text string from the second text string. (case-sensitive).
Syntax
FIND(find text,text,position)
- find text is the text you want to locate.
- text is the text where the search takes place.
- position is optional and it specifies the starting character position. If you omit position, FIND starts from the first character of the text.
Note: FIND is case-sensitive.
Example
=FIND("S","Steve Jobs") returns 1.
=FIND("s","Steve Jobs") returns 10.
=FIND("e","Steve Jobs",4) returns 5.