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).
.
Compare Text
Post Author: Zahid Farid
Related Posts '
01 JUL
Concatenate Strings
This example illustrates four different ways to concatenate (join) strings in Excel.1. Simply use the & operator to join strings.Note:...
01 JUL
Substitute vs Replace
This example shows the difference between the SUBSTITUTE function and the REPLACE function.1a. If you know the text to be replaced, use the...
01 JUL
Find vs Search
The FIND function and the SEARCH function are very similar to each other. This example shows the difference.1. To find the position of a...
01 JUL
Remove Unwanted Characters
The TRIM function returns a string with extra spaces, starting spaces and ending spaces removed. The CLEAN function removes nonprintable...
01 JUL
Lower/Upper Case
This example teaches you how to convert a text string to lower, upper or proper case in Excel.1. Use the LOWER function to convert all...