Rational
Match two text strings if they are exactly alike.
Description
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.
Syntax
= EXACT (text1, text2)
Parameters
text1– The first text string.
text2– The second text string.
Return Value
The boolean result (True or False)
Key Notes
- 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.
Keep Reading Similar Functions:
SEARCH
The SEARCH function finds the position of a specified character or sub-string within a text string. I.e., =SEARCH(“ring”,”String”,1) return “3”, “ring” begins at the third character of “String”.
FIND
The FIND function displays the numerical position of the character in a string. I.e. to find the 2nd occurrence of 8, =FIND(8,128128,4) returns 6.
LEN
The Excel LEN function counts a number of characters of a given text string excluding number formatting. For example, LEN(“Excel”) returns “5”.