SEARCH

Finds the location of text in a string. Returns the position of the first character of the given text within a string.

Sample Usage

SEARCH("sheet","Spreadsheet.com")
SEARCH("at",C5,2)

Syntax

SEARCH(search_for, text, [start_at])

• search_for - The string you want to search for. 
  
• text  - The text containing the string. 
• start_at  - [OPTIONAL] Specifies the character at which to start the search. 

Examples

SEARCH("sheet","Spreadsheet.com") returns 7 - the position of search_for  string in the  text .
SEARCH("at",C5,2) searches for the string "at" in the cell C5. It begins the search from character 2.

Notes

• SEARCH is similar to FIND except that FIND is case sensitive.
• If search_for is not found, the #VALUE! error value is returned.
• If start_at is omitted, it is assumed to be 1.
• SEARCH always returns the number of characters from the start of text , irrespective of the start_at  number specified.