Excel EXACT Function

Excel EXACT Function

Sponsored Link


Compare two text strings

Return value 

A boolean value (TRUE or FALSE)


=EXACT (text1, text2)


  • text1 – The first text string to compare.
  • text2 – The second text string to compare.

Usage notes 

EXACT will compare two text strings and return TRUE if they are the same, and FALSE if not. EXACT is case-sensitive.

You can also use the equal sign in a formula (text1=text2) to compare text strings. However, the equal sign is not case sensitive.

Sponsored Link

0 votes. 0 / 5

Excel - Excel Functions - Excel Formulas