Excel Formulas to Compare two Text Strings ~ Easy Tricks!!

Assume that you have two lists on your worksheet. Now you need to compare these input values and test if the cell contains the same value or not. How could you achieve them quickly? Today, I will introduce several tricks to compare two text strings in Excel. Let’s step into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

General Formula:

  • If you want to compare two text strings in Excel, you can use the below formula.

=EXACT(text1, text2)

Syntax Explanations:

  • EXACT – This function helps to compare two text strings and returns TRUE if they are the same or else returns FALSE. Read more on the EXACT function.
  • Text 1, Text 2 – It represents the input values.
  • Comma symbol (,) – It is a separator that helps to separate a list of values.
  • Parenthesis () – The main purpose of this symbol is to group the elements.

Practical Example:

Refer to the below example image.

  • First, we will enter the input values in Column B and Column C.
  • Now we need to compare these two input strings.
  • Select any cell and apply the above-given formula.
  • Finally, press ENTER to get the result out.


So yeah guys, this is how we can compare two text strings in Excel. I hope this helps. Feel free to ask back any questions and let us know how it goes.

Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **

Read Also: