Excel EXACT function compares two strings and returns TRUE for a perfect match, and FALSE if not. Note that this comparison is case-sensitive. In this guide, we’re going to show you how to use Excel EXACT function to compare strings and also go over some tips and error handling methods.
- All Excel versions
Excel EXACT Function Syntax
|text1||The first text string to be compared.|
|text2||The second text string to be compared.|
=IF(EXACT("Pikachu","Pikachu"),"A match!","No match.")
=IF(EXACT("Pikachu","pikachu"),"A match!","No match.")
- The equal operator (=) does a similar comparison, and returns a Boolean value similar to the EXACT function. However, this comparison is not case-sensitive.
- Excel EXACT function ignores cell formatting - dates and numbers can be compared as well.