If the two strings are exactly the same, EXACT returns TRUE.

The EXACT function takes twoarguments,text1andtext2, which should be validtext strings.

Examples

Below are two examples of the EXACT function used with hardcoded strings.

Excel formula: Cell ends with

Excel formula: XLOOKUP case-sensitive

Excel formula: INDEX and MATCH case-sensitive

Excel formula: Highlight column differences

Excel formula: Count cells that begin with

Excel formula: Data validation allow uppercase only

Excel formula: Data validation must begin with

Excel formula: Count cells equal to case sensitive

Excel formula: Highlight cells that end with

Excel formula: Match long text

Excel formula: Multiple cells have same value case sensitive

Excel formula: SUMPRODUCT case-sensitive lookup

Excel formula: Highlight cells that equal

Excel formula: Sum if case-sensitive

Excel formula: Unique values case-sensitive