Formulas and functions > Functions from A to Z

Syntax:

FIND(SearchText, Text [, StartPos])

Description:

This returns the position of the text string SearchText within the text string Text.

StartPos (optional) lets you specify the position (character) at which to start the search. If omitted, the search starts at the first character.

The FIND function is case-sensitive. To perform a non-case-sensitive search, use the SEARCH function instead.

Example:

FIND("a", "Banana") returns 2

FIND("A", "Banana") returns the error value #VALUE!, since the text string does not contain an uppercase "A".

FIND("a", "Banana", 3) returns 4

FIND("x", "Banana") returns a #VALUE! error value, since "x" does not occur in "Banana".

For example, if the word "banana" is in cell B5, you can enter the formula as follows:

FIND("a", B5) returns 2.

FIND (search for text)