FIND

Returns the position at which a string is first found within text, case-sensitive.

Usage examples 

FIND("world", "hello world", 1)

Syntax 

FIND ( search, text, [ starting ] )

  • search - any string expression to look for within text.

  • text - any string expression to search for the first occurrence of search.

  • starting - any numeric expression indicating which position to start the search.

Returns 

number - the position of the found string.

Functions reference