Searching for a particular word within a cell content in excel?

Lets say I'm searching for the word QUEEN in cells containing names in col A. If A1 has DIANA QUEEN, B1 should show YES. If A2 has NINA LAQUEEN, B2 should show YES. If A3 has IRENE CLAUDE, B3 should show NO