finding certain words within text

I've got a workbook with about 85,000 rows. Column A of the workbook contains a name, B = date, and C contains the text to be searched. See attached example.

After that, I've got columns with the words to find in C.

I'm using this formula, but it isn't working:

Please Login or Register  to view this content.

I was hoping that the CLEAN function would fix the problem but it doesn't

Can you suggest a solution? Thanks

Try just

=ISNUMBER(SEARCH(D$8,$C9))

Another way with PowerQuery

Thanks... all of these work. Sandy, did you create the powerquery range by defining it, or was it created automatically?

if column with text contain word then return True else False. That's all (Key Word: Contain)

That's great Sandy, for powerquery I'm a newbie, so didn't realize it had that function built in. I see it now when I open the edit window.

most users with excel 2016 do not know the capabilities of this software and use it in the excel 97 style

Thanks Sandy. Is there a way to eliminate the rows with "FALSE" before inserting into the worksheet? That would probably reduce its size considerably (and/or should I start a new thread on this subject)?

Great. Thanks Sandy!

You are welcome

Have a nice day