View Single Post
 
Old 12-18-2015, 07:14 AM
SumitBansal SumitBansal is offline Windows 10 Office 2013
Novice
 
Join Date: Dec 2015
Location: India
Posts: 6
SumitBansal is on a distinguished road
Default

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.
Reply With Quote