How to use EXACT function Compare Text In Excel

Oct 28, 2020 • edited Oct 31, 2020

How to use EXACT function Compare Text In Excel

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

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

Case-sensitive

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

Case-insensitive

#Tutorial#How To#Functions#Text

How to Use Circular Reference In Excel

How To Use t-Test In Excel