Checks whether two text strings are exactly the same.
Синтаксис
EXACT(text1, text2)Аргументы
text1обязательно
The first text string to compare.
text2обязательно
The second text string to compare.
The EXACT function compares two text strings and returns TRUE if they are identical, including case sensitivity. It ignores formatting and is useful for verifying data entries where capitalization matters.
=EXACT("Apple", "apple")→FALSEReturns FALSE because the function is case-sensitive.
=EXACT("Excel", "Excel")→TRUEReturns TRUE because both strings are identical.
Select a cell
Click on the cell where you want the result to appear.
Enter the formula
Type =EXACT(text1, text2) and replace the arguments with your cell references or text strings.
Yes, unlike the standard equal sign (=) operator, EXACT is strictly case-sensitive.