EXACT(text1,text2) checks to see if two text values are identical : EXACT « Text functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Text functions
  3. EXACT
Input the formula: =EXACT(A2,B2)
Input the formula: =EXACT(A2,B2)
22.8.EXACT
22.8.1.EXACT(text1,text2) checks to see if two text values are identicalEXACT(text1,text2) checks to see if two text values are identical
22.8.2.=EXACT("zero ","zero") returns FALSE because the first string contains a trailing space=EXACT(