PDA

View Full Version : Match words in 2 cells



blackie42
07-11-2014, 07:17 AM
Hi,

Mr A Smith in cell A1, Mr Alan Smith in cell A2 - I'd like cell A3 to say at least one of the words matches - any help on the formula appreciated.

Could be Mrs & Mrs A Smith vs Alan Smith etc

thanks in advance
Jon

blackie42
07-11-2014, 07:52 AM
and ignoring mr & mrs - so in this case just picking up 'smith'

thanks