String Comparision in Excel

1. To compare strings in excel we need to use the EXACT function.
2. EXACT function takes two arguments. If both the arguments are same(Case Sensitive) then the result will be TRUE else the result is FALSE.
3. Syntax:  EXACT(arg1,arg2)

Below is a sample excel sheet on which we use the function.

• =EXACT(A1,B1)  returns FALSE
• =EXACT(A1,”Krishna”) returns FALSE
• =EXACT(A1,”Krishna”) returns TRUE
• =EXACT(“Krishna”,”Krishna”)  returns TRUE
• =EXACT(“Krishna”,”Krishna”) returns FALSE