Clean up text
Compare two cells, including capitals
=IF(EXACT(A2,B2),"Same","Different")How it works in Excel
- EXACT is true only if the text matches perfectly.
- Unlike =, it treats capitals as different.
- Use =A2=B2 if capitals do not matter.
The idea in general
It compares the two letter by letter.
What I assumed
- The two values are in A2 and B2.
Check the result on your own data before relying on it.