Excel SEARCH function
Function SEARCH
Description Excel SEARCH function locate one text string within another text string, and return the number of the starting position of the first text string from the first character of the second text string
Syntax SEARCH(find_text, within_text, [start_num])
find_text Required. The text that you want to find.
within_text Required. The text in which you want to search for the value of the find_text argument.
start_num Optional. The character number in the within_text argument at which you want to start searching.
Example: