Summary

The Excel EXACT function compares two text values and returns TRUE only when they match exactly. That includes uppercase and lowercase letters, spaces, and punctuation.

EXACT is different from the normal = comparison. In Excel, ="Apple"="apple" returns TRUE because the standard comparison ignores case. EXACT does not ignore case.

Syntax

=EXACT(text1, text2)

text1 and text2 are the two values you want to compare. Both arguments are required.

Arguments

• text1 - [Required] The first text value.
• text2 - [Required] The second text value to compare against.

EXACT vs Other Functions

EXACT fills a specific gap: it gives you a case-sensitive text comparison. Most other common comparison tools in Excel are case-insensitive by default.

Using EXACT

EXACT is useful when case carries meaning. That can happen in revision codes, imported identifiers, passwords, or validation checks where "REV-A" should not be treated as the same as "rev-a".

If two values look the same but EXACT still returns FALSE, the problem may be an extra space or another hidden character. In that case, trimming or cleaning the text before comparison can help.

• Use EXACT when uppercase and lowercase letters must be treated as different.
• Use EXACT inside IF when you want a readable result instead of TRUE or FALSE.
• Use TRIM with EXACT if hidden spaces may be affecting the comparison.

Example 1 - Seeing the Difference Between EXACT and Equals

This example shows the main reason EXACT exists. The normal comparison ignores case, while EXACT does not.

="Excel"="excel"         // TRUE
=EXACT("Excel","excel") // FALSE

Example 2 - Comparing Two Cells

EXACT works the same way with cell references. If even one letter differs in case, the result is FALSE.

=EXACT(A1,B1)
// "Pass123" vs "pass123" -> FALSE

Example 3 - Showing a Human-Readable Result

Wrapping EXACT inside IF can make the result easier to scan in a worksheet. This is useful in review or validation columns.

=IF(EXACT(C1,D1), "Match", "Different")

Example 4 - Checking Against a Fixed Expected Value

EXACT can compare a cell against a required text value when the case must match exactly.

=EXACT(E1, "REV-A")
// TRUE only if E1 contains exactly "REV-A"

EXACT is often enough for one-to-one checks, but case-sensitive counting needs a different pattern such as SUMPRODUCT with EXACT.

Conclusion Recap

• Summary: EXACT compares two text values with case sensitivity.
• Syntax: =EXACT(text1, text2).
• Key point: EXACT does what the standard = comparison does not: it respects letter case.
• Practical usage: Validation checks, revision codes, and any text where case matters.
• Best pattern: Use EXACT inside IF when the worksheet should show a readable label instead of TRUE or FALSE.