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).
How to use COMPARE AND TEXT formula in Excel
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment