This article will show you two ways to compare text in Excel. The first way is case sensitive and the other is case insensitive.
| Join the channel Telegram of the AnonyViet 👉 Link 👈 |
How to compare text in Excel
1. Use the EXACT (case sensitive) function.
Explanation: the string “Frog” in cell A1 and the string “frog” in cell B1 are not exactly equal (the first character is uppercase and the first character is lowercase).
2. Use the formula =A1= B1 (case insensitive).
3. Add the IF function to replace TRUE and FALSE with a word or message. The formula below uses the EXACT function (see step 1).
4. You can review the article about the item in this series to do as shown below.
In addition, you can also view many other excel articles here.
