Compare text in Excel

This example demonstrates two ways to compare text in Excel. One is case sensitive, the other is not.

1. Use the function EXACT (EXACT) to perform a case-sensitive comparison:

   =EXACT(A1,B1)

   =СОВПАД(A1;B1)

2. Use the formula =A1=V1to perform a case-insensitive comparison: