Use
EXACT function is used to compare different text strings or values and results with TRUE if strings are exactly same otherwise it will return FALSE. It is case-sensitive but ignores formatting differences.
Syntax
=EXACT(text1, text2)
where, arguments text1 and text2 are different text strings or values, to whom you need to compare.
Example
To convert text values and strings in the above-mentioned screenshot, do the following steps:
1. Go to cell C1, type =EXACT(A1,B1) and press Enter.
In result, Excel will show TRUE if both values match otherwise FALSE will appear.
2. Copy cell C1 by pressing Ctrl + C and paste it to remaining cells by pressing Ctrl + V after selecting the particular cell.
Reasoning Table
Column A | Column B | Formula Results | Reasons |
Alphabets | alphabets | FALSE | Small letter in column B |
Text | Text | TRUE | – |
50 | 50 | FALSE | Value in Column A is 49.9 which has been rounded to 50 |
A BCD | ABCD | FALSE | Space between alphabets in column A |