Exceljet

Quick, clean, and to the point

Compare two strings

Excel formula: Compare two strings
Generic formula 
=EXACT(text1, text2)
Explanation 

If you need to compare two text strings in Excel to determine if they're equal, you can use the EXACT function. For example, if you want to compare A2 with B2, use:

=EXACT(A2,B2)

If the two strings are identical, EXACT will return TRUE. If not, EXACT will return FALSE. You can use this result inside the IF function to display a message or make a conditional calculation. For example, to display the message "Yes" for a match and "No" if not, use:

=IF(EXACT(A2,B2),"Yes","No")

Note the EXACT function is case sensitive. If you don't care about case, you can simply use the equal sign like so:

=A2=B2

This formula will return TRUE or FALSE, and will treat "Apple" and "apple" as the same.

Author 
Dave Bruns

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.