![]() ![]() ![]() ![]() If you just want to compare two cells, but aren’t concerned about leading spaces, trailing spaces, or extra spaces, use the TRIM function to remove them, for one or both of the cells. ![]() (Upper and lower case versions of the same letter are treated as equal). If the cell contents are the same, the result is TRUE. The quickest way to compare two cells is with a formula that uses the equal sign. We’ll start with a simple check, then move up the formula ladder, for more complex comparisons. Aside from staring at them closely, how can you compare two cells in Excel? Here are a few functions and formulas that check the contents of two cells, to see if they are the same. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |