FIND (search for text)

<< Click to Display Table of Contents >>

FIND (search for text)

Syntax:

FIND(SearchedText, Text [, StartPos])

Description:

Returns the position of the text string SearchedText 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 upper case "A".

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

See also:

SEARCH, REPLACE, SUBSTITUTE, EXACT, MID