EXACT ( ) Compares two text strings and returns TRUE if they are exactly the same. We can also use IF function to Compare two Columns but with IF function, it doesn’t matter if the text is written in Upper or Lower Case. The EXACT is case-sensitive and Can distinguish between Upper and Lower Case & it also ignores formatting differences.
SYNTAX: EXACT (text1,text2)
text 1: First text String text 2: Second text String
If the two items of text are exactly the same the result of TRUE will be shown.
If there is any difference in the two items of text the result of FALSE will be shown.
EXACT Basics Workbook (71 downloads)
Download the workbook and practice with your Choice of Text.