EXACT

EXACT(text1, text2)

Returns the boolean True or False based on whether two strings match exactly.

text1	The first text string.
text2	The second text string.

REMARKS

* This function is case sensitive.
* This function does not support wildcards (? and *).
* This function is similar to using the "=" character in a formula except the equal sign is not case sensitive. See Example 1.
* If the arguments are cell references then any formatting differences are ignored.
* The arguments can be literal strings enclosed in quotation marks, formulas evaluating to numerical values or cell references containing text, numerical values.
* You can use the FIND to return the position of a substring within a larger text string. This is case sensitive.
* You can use the REPLACE to return the text string with a number of characters replaced.
* You can use the SEARCH to return the position of a substring within a larger text string. This is not case sensitive.
* For the Microsoft documentation refer to support.microsoft.com

	A
1	="hello"="HELLO" = True
2	=EXACT("hello", "HELLO") = False
3	=EXACT("wOrd", "word") = False
4	=EXACT("WORD", "word") = False
5	=EXACT("word","word ") = False
6	=EXACT(10, 10) = True
7	=EXACT(, ) = True
8	=EXACT("BIG", "big") = False
9	=EXACT(40, 50) = False
10	=EXACT("", "") = True