Finds the location of text in a string. Returns the position of the first character of the given text within a string.
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.
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.