Need to find a set of letters from a group of letters in excel

Closed
Ravi - Feb 11, 2016 at 08:53 PM
Hello,

I need to find a set of letters from a group of letters or words within a cell in excel.
For ex, If the address is filled in a cell, I need to find just the name of the road.
Address: Raj, No.8, link road, Mumbai.
From this I just need to find Mumbai and record this in a new cell as Yes or No.

Please help