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
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