How to compare two cell(string) in excel

In the following example, as you can see in the below photo, comparing two cell with each other can be identified by the EXACT function.

=EXACT(A2,B2)----->>>>answer is  FALSE
=EXACT(A5,B5)----->>>>answer is  TRUE
=EXACT("WORD","word")----->>>>answer is  FALSE

EXACT function

The EXACT function is one of the TEXT functions of Excel.

It checks whether two text strings are exactly the same, and returns TRUE or FALSE. EXACT is case-sensitive.

EXACT arguments

The EXACT function has 2 arguments:

1. Text1 is the first text string.

2. Text2 is the second text string.

Related posts:

Excel RIGHT Function Excel HARMEAN Function Excel TEXT Function RTD Function in Excel