Use this formula is cell C2, and copy paste in all the cells:
=OR(LEFT(A2,SEARCH("/",A2)-1)=LEFT(B2,SEARCH("/",B2)-1),RIGHT(A2,LEN(A2)-SEARCH("/",A2))=RIGHT(B2,LEN(B2)-SEARCH("/",B2)))
It would return a TRUE when there is a match and FALSE is there is not.
|