Forum Discussion
olgreen72
Jul 26, 2021Copper Contributor
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 identify these "incorrect" cells (see attached file also)
That could be
=IF(ISNUMBER(SEARCH(TRIM(A2)& " ",B2)), "ERROR First Name is part of Last Name", "")Please check in attached.
3 Replies
- SergeiBaklanDiamond Contributor
That could be
=IF(ISNUMBER(SEARCH(TRIM(A2)& " ",B2)), "ERROR First Name is part of Last Name", "")Please check in attached.
- olgreen72Copper ContributorThanks very much Sergei - much appreciated!
- SergeiBaklanDiamond Contributor
olgreen72 , you are welcome