Partial Text Match between two cells

[olgreen72]

I am looking for a formular identifying partial text matches between two cells. e.g. two columns (First Name and Last Name). In some cells the first name is also part of the last name and I want to identify these "incorrect" cells (see attached file also)

[#2 · Accepted solution]

@olgreen72 

That could be

=IF(ISNUMBER(SEARCH(TRIM(A2)& " ",B2)), "ERROR First Name is part of Last Name", "")

Please check in attached.

[#3]

Thanks very much Sergei - much appreciated!

[#4]

@olgreen72 , you are welcome