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
Related Posts
How to remove unwanted characters in Ms Excel 12 Sep 20140The TRIM function returns a string with extra spaces, starting spaces and ending spaces removed. Th...Read more »
How to use words and number of words on Excel formulas or data 12 Sep 20140This example describes how to count the number of words in a cell. 1a. The TRIM function retur...Read more »
How to calculate the sum Product in MS Excel12 Sep 20140To calculate the sum of the products of corresponding numbers in one or more ranges, use Excel's pow...Read more »
How to Copy Exact formula in Excel 12 Sep 20140When you copy a formula, Excel automatically adjusts the cell references for each new cell the formu...Read more »
How to Play with DateDif formula in Ms Excel12 Sep 20140To get the number of days, weeks or years between two dates, use the DATEDIF function. The DATEDIF f...Read more »
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment
Click to see the code!
To insert emoticon you must added at least one space before the code.