EXACT function
The Excel EXACT function returns TRUE or FALSE as a result after comparing two strings. It has been in Excel for a very long time.
The syntax of the EXACT function has the following arguments:
EXACT (text1, text2)
Text1, Text2 – A cell reference that contains the text whose values you want to compare.
Excel function EXACT – Reason for use
Many users would wonder Why? isn’t it enough to use the equals sign? When we want to compare two strings or the contents of two cells, the equal sign “does not see” the difference between lowercase and uppercase letters. For example. Belgrade and Belgrade are equal words for the sign of equality, and not for the EXACT function.
Another reason for the existence of such a function is the ability to examine the equality of strings in a complex nesting function.