SEARCH

SEARCH the location of the search string within text after position start

Synopsis

SEARCH(search,text,start)

Arguments

search: search string

text: search field

start: starting position, defaults to 1

Description

search may contain wildcard characters (*) and question marks (?). A question mark matches any single character, and a wildcard matches any string including the empty string. To search for * or ?, precede the symbol with ~.

Note

This search is not case sensitive. If search is not found, SEARCH returns #VALUE! If start is less than one or it is greater than the length of text, SEARCH returns #VALUE!

Microsoft Excel Compatibility

This function is Excel compatible.

See also

FIND, SEARCHB.