I would like that if my text cell includes a word from my word list, then excel count it how many words use from my bag list in the text cell .
For example my word list "good,perfect,nice"
and my text cell is written as" today the weather is good and nice"
then excel must count it as "2"
could you help for this:/
thank you very much
Bookmarks