#1 Excel tutorial on the net
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).
8/10 Completed! Learn more about text functions >
Back to Top: Compare Text | Go to Next Chapter: Lookup & Reference Functions
Excel Easy • Free Excel Help • Copyright (c) 2010-2016 • All rights reserved
Microsoft Excel Tutorial | How to use VBA | Excel Formulas | Drop-down List