The FINDTEXT function finds one text string within another and returns the position of the character at which the two text strings first match.
FINDTEXT is case sensitive and does not allow wildcard characters (in this it differs from SEARCHTEXT – see SEARCHTEXT).
find_text is the text you wish to find.
within_text is the object text.
start_num is the position of the character in within_text from which you want to begin the search.
If find_text is "" (empty) the character at start_num is returned. If start_num is omitted it is assumed to be 1. The #VALUE error message is returned if FINDTEXT fails to find a match.
For example:
FINDTEXT("br", "abracadabra",5) returns 9
FINDTEXT("r", "Robertson", 1) returns 5
FINDTEXT("R", "Robertson", 1) returns 1
FINDTEXT(" ", "Mr Smith") returns 3
See also: