Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Text > EXACT
 

EXACT(text1, text2)

 
 Returns the boolean value based on whether two strings match exactly.

 text1The first text string.
 text2The second text string.

 REMARKS
 
  		• This function is case sensitive.
     
  		• The arguments can be literal strings enclosed in quotation marks, cells references containing text, numeric values or formulas evaluation to numeric values.

     EXAMPLES
     
     A
    1=EXACT("word","word") = True
    2=EXACT("wOrd","word") = False
    3=EXACT("WORD","word") = False
    4=EXACT(10,10) = True
    5=EXACT(,) = True
    6=EXACT("BIG","big") = False
    7=EXACT(40,50) = False
    8=EXACT("","") = True
    		 
     Functions - E | Index - E | Text Manipulation | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top