SOLVED

Partial Text Match between two cells

%3CLINGO-SUB%20id%3D%22lingo-sub-2586032%22%20slang%3D%22en-US%22%3EPartial%20Text%20Match%20between%20two%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2586032%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20looking%20for%20a%20formular%20identifying%20partial%20text%20matches%20between%20two%20cells.%20e.g.%20two%20columns%20(First%20Name%20and%20Last%20Name).%20In%20some%20cells%20the%20first%20name%20is%20also%20part%20of%20the%20last%20name%20and%20I%20want%20to%20identify%20these%20%22incorrect%22%20cells%20(see%20attached%20file%20also)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2586032%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2586067%22%20slang%3D%22en-US%22%3ERe%3A%20Partial%20Text%20Match%20between%20two%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2586067%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1112510%22%20target%3D%22_blank%22%3E%40olgreen72%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat%20could%20be%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DIF(ISNUMBER(SEARCH(TRIM(A2)%26amp%3B%20%22%20%22%2CB2))%2C%20%22ERROR%20First%20Name%20is%20part%20of%20Last%20Name%22%2C%20%22%22)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3EPlease%20check%20in%20attached.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2586124%22%20slang%3D%22en-US%22%3ERe%3A%20Partial%20Text%20Match%20between%20two%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2586124%22%20slang%3D%22en-US%22%3EThanks%20very%20much%20Sergei%20-%20much%20appreciated!%3C%2FLINGO-BODY%3E
New Contributor

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)

 

 

3 Replies
best response confirmed by olgreen72 (New Contributor)
Solution

@olgreen72 

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