Match two text strings if they are exactly alike.
The Excel EXACT function display a Boolean result (True or False) after matching two text strings if they are exactly same. The EXACT function also identifies case-sensitive differences between two text.
= EXACT (text1, text2)
text1– The first text string.
text2– The second text string.
The boolean result (True or False)
- In case of both texts matches, the result will be TRUE, otherwise return FALSE.
- The EXACT function will pick case sensitive difference between two strings as well.
- Although the function won’t be able to match the formatting difference.