Excel Formulas to Compare two Text Strings ~ Easy Tricks!!
Tags: excelformula, excelformulas
Published: 2021-06-16 10:41:41

---
title: Excel Formulas to Compare two Text Strings ~ Easy Tricks!!
published: true
date: 2021-06-03 16:32:01 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-compare-two-text-strings/
---

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](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Compare two text strings](https://geekexcel.com/wp-content/uploads/2021/06/Compare-two-text-strings.png)](https://geekexcel.com/excel-formulas-to-compare-two-text-strings/compare-two-text-strings/#main)<figcaption id="caption-attachment-46028">Compare two text strings</figcaption>

## General Formula:

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

**=[EXACT](https://geekexcel.com/how-to-use-exact-function-in-microsoft-excel-365/)(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**](https://geekexcel.com/how-to-use-exact-function-in-microsoft-excel-365/).
- **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.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/06/Input-Ranges-7.png)<figcaption id="caption-attachment-46026">Input Ranges</figcaption>

- Select any cell and apply the above-given formula.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/06/Enter-the-formula-10.png)<figcaption id="caption-attachment-46029">Enter the formula</figcaption>

- Finally, press  **ENTER**  to get the result out.

![Result](https://geekexcel.com/wp-content/uploads/2021/06/Result-9.png)<figcaption id="caption-attachment-46027">Result</figcaption>

## Wrap-Up:

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](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Read Also:

- **[Excel Formulas to Test the Cells that Contains Specific Text!!](https://geekexcel.com/excel-formulas-to-test-the-cell-that-contains-specific-text/)**
- **[How to Count missing values in a list in Excel Office 365?](https://geekexcel.com/how-to-count-missing-values-in-a-list-in-excel-office-365/)**
- **[How to Increment a Value by Row or Column in Excel Office 365?](https://geekexcel.com/how-to-increment-a-value-by-row-or-column-in-excel-office-365/)**
- **[Excel Formulas to Add a Line Break Based on the Current OS ~ Quickly!!](https://geekexcel.com/excel-formulas-to-add-a-line-break-based-on-the-current-os-quickly/)**