| Syntax |
| =EXACT(text1,text2) |
| Purpose / Description |
| Returns TRUE if the two text strings are exactly the same, otherwise returns FALSE. This comparison, unlike the standard comparison operator, is case sensitive. |
| Arguments |
| Name |
Type |
Description |
| text1 |
text string |
A constant, reference or nested expression that provides the first text string to be compared to the second one. |
| text2 |
text string |
A constant, reference or nested expression that provides the second text string to be compared to the first one. |
| Return Values |
| Type |
Specific Value |
Description |
| logical |
|
Returns TRUE if the two text strings are exactly the same character-by-character, including the case, otherwise returns FALSE. |
| error |
|
Any errors referenced by arguments are returned due to propagation of error values. |
| Notes / Comments / Advice / Warnings |
| Note: |
"E"="e" is TRUE, but EXACT("E","e") is FALSE |
| Examples: |
Open / download sample workbook: EXACT.xlsx |
| |