Documentation/How Tos/Calc: FIND function

FIND

Returns the position of a string of text within another string.

Syntax:

FIND(findtext; texttosearch; startposition)

returns the character position of the first occurrence of findtext within texttosearch.

startposition (optional) is the position from which the search starts.

The search is case-sensitive.

A failed search gives the #VALUE! error.

Example:

FIND("yo"; "Yoyo")

returns 3.

FIND("cho"; "choochoo"; 2)

returns 5.

See also:

REPLACE, SEARCH, SUBSTITUTE, EXACT

Text functions

Functions listed alphabetically, Functions listed by category