EXACT

EXACT(text1, text2)

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

text1The first text string.
text2The 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
* For the Google documentation refer to support.google.com

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


© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited Top