The function SEARCH locates one text string within a second text string, and returns the number of the starting position in the second text string.
Syntax:
=Search(lookup string, search string)
Lookup String. is the text you want to find
Search string. is the text string in which you want to search for the lookup string