How to use EXACT function in Excel?

The `EXACT` function in Excel is used to compare two text strings and determine if they are exactly the same, including letter casing. The function returns `TRUE` if the strings are identical, and `FALSE` otherwise. Here’s how you can use the `EXACT` function:

Syntax

EXACT(text1, text2)

text1: The first text string you want to compare.
text2: The second text string you want to compare.

Example

Let’s say you want to compare two cells, A1 and B1, to check if they contain the same text.

   =EXACT(A1, B1)

Enter your data:

A1: “Excel”
B1: “excel”

Use the `EXACT` function to compare the two cells:
The function will return `FALSE` because “Excel” and “excel” have different capitalizations.

Points to Note

The `EXACT` function is case-sensitive. This means “Text” and “text” will be considered different.
This function is particularly useful for situations where case sensitivity is important, such as validating passwords or checking for exact matches in data analysis.
It can also be used for direct input strings, like `=EXACT(“Apple”, “apple”)`, which would return `FALSE`.

By using the `EXACT` function, you can easily verify if text strings match exactly as needed.

facebooklinkedin