EXACT function

Category: Text
Introduced: Excel 2003

Summary

Checks to see if two text values are identical

Syntax

EXACT(text1, text2) The EXACT function syntax has the following arguments:
• Text1 Required. The first text string.
• Text2 Required. The second text string.

Example

=EXACT(A2,B2)
=EXACT(A3,B3)
=EXACT(A4,B4)

Microsoft Support Page

https://support.microsoft.com/en-us/office/exact-function-d3087698-fc15-4a15-9631-12575cf29926

Back to Functions