Try thisC2 cell is our SearchB2 cell is our Text where we search=EXACT(C2,MID(B2,FIND(C2,B2,1),LEN(C2)))