I have two columns with text and I want to match, row by row, any word in column A cell to any word in column B cell.
For example:
A1: The cat sat on the mat
B1: I have a dog and a budgie and a cat
I want a formula in cell C1 which pulls out the word cat as appearing in both A1 and B1, is this possible?
The real life spread sheet is actually lists of companies and I need to know if they fulfil two criteria however there are variable numbers of companies in each cell and they are often written differently, e.g. A1 = Tesco but B1 = TESCO PLC.
Any help gratefully received!
Thanks,
Samantha
Bookmarks