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: