<< 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