FIND function

Category:Text

Name in English:FIND

That makes?

Finds the position of a text within another text and returns the position of the character where it was found. It is case sensitive.

Syntax

FIND (search_text, within_text, [start_num])

  • search_text (required ): The text to be found.
  • within_the_text (required ): The text string to search for.
  • start_num (optional ): The character number where the search starts. If it is omitted then the search will start from the first character.

Examples

FIND (“o”, “hello”) = 2
FIND (“h”, “hello”) = 1

Leave a Comment