Searching For A String In Multi-Lined Row

Best approach for searching for a piece of string from a multi-lined cell. I am trying to do it via VBA but can't seem to figure it out. I tried FIND and Instr. I was thinking of converting the multiple lines into a single line then do an instr comparison from the result but I don't know how to do it.

Sample:

String to search = "MARY"
Output Location value

Table:
Location-----Names
US ----------JOHN AND RINGO
----------MARTHA YULET

UK-----------JAMES THE FIRST
-----------HENRY THE FIFTH
-----------MARY HAD A LITTLE LAMB
-----------JOHNNY BRAVO

Cells in column "Names" has multiple lines Cells in column "Location" are not merged....