Hi,
Thanks for the formulas, it works great.
Do you think it is possible to find which word has been found (if a word of the list exists, it will be unique and appears only one time in a cell in column A)
Thanks,
Hello,
Let's say in column A I have a list of cells with a lot of text in each cell.
In column B, I have a a bunch of key words that I would like to find in column A.
For each cell of column A, i would like to test if it contains at list one of the word of the list in the column B.
Can...