Skip to main content

FIND

The FIND function locates one text string within another text string and returns the starting position of the found text.

Syntax​

=FIND(find_text, within_text, [start_num])

Parameters​

  • find_text: The text to find
  • within_text: The text to search within
  • start_num: Optional. The character position at which to start the search

Examples​

=FIND("world", "Hello world") // Returns 7
=FIND("o", "Hello world", 5) // Returns 7
=FIND("x", "Hello world") // Returns #VALUE! error (not found)