FIND

Locates text within a text string, then returns the offset position of the first character in the string.  The offset is expressed in the number of characters from the beginning of the searched text string.  The first character in the string is 1, the second is 2, and so forth.  This function is identical to the SEARCH function, except it IS case-sensitive.

Syntax

FIND(find-text,source-text,{start-offset})

Arguments

find-text	Text or cell reference to find.
source-text	Text or cell reference to search.
start-offset	Offset position in the text string to begin the search. The first character in the string is 1, the second 2, and so forth.

Example

FIND ("ss","Mississippi") returns 3
FIND ("ss","Mississippi",5) returns 6