SEARCH

SEARCH

Synopsis

SEARCH(search_string,text[,start_num])

Description

SEARCH returns the location of the search_ string within text. The search starts with the start_num character of text text. If start_num is omitted, it is assumed to be one. The search is not case sensitive.

search_string can contain wildcard characters (*) and question marks (?). A question mark matches any character and a wildcard matches any string including the empty string. If you want the actual wildcard or question mark to be found, use tilde (~) before the character.

  • If search_string is not found, SEARCH returns #VALUE! error.
  • If start_num is less than one or it is greater than the length of text, SEARCH returns #VALUE! error.
  • This function is Excel compatible.

Examples

SEARCH("c","Cancel") equals 1.

SEARCH("c","Cancel",2) equals 4.

See also

FIND.