SEARCH

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 FIND function, except it is not case-sensitive.

Syntax

SEARCH(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 default is 0 (the beginning of the string). The first character in the string is 1, the second 2, and so forth.

Examples

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

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 default is 0 (the beginning of the string). The first character in the string is 1, the second 2, and so forth.