with your code from http://www.ozgrid.com/forum/showthread.php?t=197406 I need exact oposite, I made it with small change of your code and I need to exclude some words like "to, and. it, is....ect)
same example :
I am happy and sad
I am extremely happy
I am happy
I am very happy
I am very very happy
In all sentences are word happy.
and in column B need:
(not if exist: I, am, are, to, is, it...)
and if are more words then put all in column B
Not consider same word, room and rooms. Need only exact word.
Can you help me?