Forum Discussion
Solved
Partial Text Match between two cells
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 i...
That could be
=IF(ISNUMBER(SEARCH(TRIM(A2)& " ",B2)), "ERROR First Name is part of Last Name", "")Please check in attached.
That could be
=IF(ISNUMBER(SEARCH(TRIM(A2)& " ",B2)), "ERROR First Name is part of Last Name", "")Please check in attached.
Thanks very much Sergei - much appreciated!
olgreen72 , you are welcome