Two ways to Compare Text in Excel

by

Case-sensitive and case-insensitive ways to Compare Text in Excel.

This example shows two ways to compare text in Excel. One is case-sensitive and one is case-insensitive.

Worked Example:   Perform case-sensitive Lookup in Excel
Worked Example:   Check multiple cells are equal in Excel

1. Use the EXACT function (case-sensitive).

Worked Example:   EXACT function: Description, Usage, Syntax, Examples and Explanation

2. Use the formula =A1=B1 (case-insensitive).

Leave a Reply

Your email address will not be published. Required fields are marked *