Searching for multiple words in a cell

Thank you so much for your very helpful reply! The vba worked perfectly for my example.

I tried replicating this for a more complicated text - the US Constitution as an example but the results aren't so consistent. There's also a problem with the "0" and commas...since comma separators aren't necessary, I'm wondering if it would make the formula simpler if they were left out?

I was actually quite skeptical before about whether excel had the power to do this type of search but your macro gave me a lot of confidence. If you have any further suggestions on this, I really would appreciate it!

(I've attached my example file to this post)

Edit: can't attach the file for some reason...

Try condensing the file down or zipping it.