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.