FIND()

FIND() -This functions looks for a string of text within another string. You can define where to begin the search. The search term can be a number or any string of characters. The search is case-sensitive.

Syntax

FIND(find_text; text; position)

find_text refers to the text to be found.

text is the text where the search takes place.

position (optional) is the position in the text from which the search starts.

Example:

=FIND("f";"abcdefghijk") returns 6

=FIND("f";"a b c d e f g h i j k") returns 11

=FIND(81;3958362387817) returns 14