Forum Discussion
Text Filter
Hello All, Would you be able to tell me how to filter two columns of individual names for differences, that rule out middle initials? I've tried using a filter that would tell me if the nam...
Hi,
Please try this formula to compare two names regardless of the middle initial:
=TRIM(LEFT(A1,FIND(" ",LOWER(A1),1))) & " " & TRIM(MID(A1,FIND(" ",LOWER(A1),FIND(" ",LOWER(A1),1)+1)+1,LEN(A1)-FIND(" ",LOWER(A1),1)+1))=TRIM(LEFT(B1,FIND(" ",LOWER(B1),1))) & " " & TRIM(MID(B1,FIND(" ",LOWER(B1),FIND(" ",LOWER(B1),1)+1)+1,LEN(B1)-FIND(" ",LOWER(B1),1)+1))
The formula is found in this https://www.extendoffice.com/documents/excel/1779-excel-remove-middle-initial.html, I've applied it on two cells and compare them in terms of equality using = sign.
Regards
