Compare two strings in Excel

To compare text strings in Excel, you can simply use the comparison operator (=).

=A1=B1

Comparing strings with EXACT

The EXACT function works similarly as the comparison operator, but there are some differences between these two approaches.

The function takes two parameters, which represent two strings.

=EXACT(string1, string2)

Let’s compare these two methods using this example:

We can see that the equal operator is case insensitive, while the EXACT function is not.