![]() ![]() Case-sensitive text comparison can be done using the Excel EXACT function: In some situations, it may be important not only to compare text values of two cells, but also to compare the character case. For example:Īs you see in the screenshot below, both formulas compare text strings, dates and numbers equally well:Ĭase-sensitive formula to compare strings in Excel If you want to output your own texts for matches and differences, embed the above statement in the logical test of the IF function. The result of the formula are Boolean values TRUE and FALSE. Where A1 and B1 are the cells you are comparing. ![]() To compare two cells in Excel ignoring case, use a simple formula like this: Case-insensitive formula to compare 2 cells There are two different ways to compare strings in Excel depending on whether you seek case-sensitive or case-insensitive comparison.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |