Question: how to find the difference between 2 strings in excel?
Answer: =EXACT(A2,B2) If the two strings are identical, EXACT will return TRUE. If not, EXACT will return FALSE. ...  =IF(EXACT(A2,B2),"Yes","No") Note the EXACT function is case sensitive. ...  =A2=B2. This formula will return TRUE or FALSE, and will treat "Apple" and "apple" as the same.