Want to get free access to our Excel functions course?

Fill in your e-mail address and telephone and we will give you 7 days free access to our course The Excel Functions Guide.

Share

There are two different way of comparing text in Excel. The EXACT function is case-sensitive, while the simple formula using an equals sign is case-insensitive.
Both methods return either TRUE or FALSE depending on how the given texts match.
We’ll write Equals, EXACT, and then select the two texts we want to compare, B10, and C10. We’ll then copy down.
As we can see, only the texts that are exactly the same in terms of capitalization are deemed true by the EXACT function.
However, if we don’t want the capitalization to be a factor when comparing text, we simply need to type equals, B10, Equals, C10. And copy down.
Now we see that only the spelling itself plays a part in whether the formula is true or false.
In this lesson we have looked at two ways to compare text in Excel.