Formula to search for one word in adjacent cell

Hi Guys,

I've got a long list of company names, i'm trying to create a formula to see if they match but the problem is the names won't match exactly (e.g it would be Joe Bloggs Limited & Joe blogg's ltd). I've thought about it and think the best way to see if they match would be to take the first word from the first cell (in this case Joe) and then search for it in the next cell and return TRUE if it exists anywhere in the cell and FALSE if not.

Any help is much appreciated, or if anyone has some alternative ideas as to how I could do it, it would be much appreciated.

Thanks,

Thanks,

I've managed to get it working.

Now im just wondering if its possible to search for a word (in cell A1 for example) in multiple cells (say B1:B1000) and to return the name in the first cell it finds?

Thanks very much for all your help