Question: how to compare two strings for similarity and highlight differences in excel?
Answer: Compare two strings with formula 1. Select a blank cell C2, enter formula =EXACT(A2, B2) into the Formula Bar, and then press the Enter key. See screenshot: Note: In the formula, A2 and B2 are the cells containing the comparing strings.