Compare Text

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).



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

.