In B4 and D4, the same way has Delhi, which is matching, so the result is TRUE. Summary of Example#2: As we can see in the result of the sheet 2 examples in Excel, there is B2 is Melbourne and D2 is Delhi which is not matching, so the result is FALSE.
#TEXT COMPARE ONLINE PLUS#
Step 4: Apply the above formula to all we can drag down on clicking the Plus sign of the E2 cell in the Excel sheet. Step 3: Now click on the Enter button, the result will be shown based on the input data. Step 2: Click on the E2 cell, apply the EXACT function, select the B2 cell, apply the EXACT function, and select D2. Step 1: Go to Sheet 2 in the excel sheet where a user wants to be compared the data the user wants to check Home city and Preferred city, so apply the formula in the E column to compare.
#TEXT COMPARE ONLINE HOW TO#
How to Compare the column data in Excel, which the user wants to match with the case of text? If we see the 5 th Row where B2 have Goa and D2 have GOA, their case is different in both the cells, but the equal function will not consider the case as it’s a case insensitive, so the result will be TRUE. Similarly, in B4 and D4, we have Delhi, which matches, so the result is TRUE. Summary of Example #1: As we can see in the result of example 1, there is B2 in Melbourne, and D2 is Delhi which is not matching, so the result is FALSE. Step 5: Apply the above formula to all we can drag down on clicking the Plus sign of the E2 cell. Step 3: Click on the E2 column and apply equal sign (=), Select B2 cell and put an equal sign, and select D2 Step 2: The user wants to check Home City and Preferred City, so apply the formula in the E column to compare in Excel
Step 1: Go to Sheet 1 in the Excel sheet, which a user wants to compare. You can download this Text Compare Excel Template here – Text Compare Excel Template Compare Text in Excel – Example#1Ĭomparing for the two City in the employee table in Excel without caring about the case of text, two texts are Home city and Preferred City. Let’s understand the working of compare text in excel with few examples. To compare text in excel is very easy and simple to use. =EXACT (A1, B1) > TRUE How to Compare Text in Excel? If the two texts are identical, then it will return TRUE if not, then it will return FALSE.Įx: There are two texts A1 is the ‘ String’, and B1 is ‘ string’ then result of the function will be TRUE
It is case insensitive, so when we do not care about the case, we need to prefer this to compare the text. =EXACT (A1, B1) > FALSE Method #2 – Equal Sign (=) If the two texts are identical, it is case sensitive then it will return TRUE if not, then it will return FALSE.Įx: There are two texts A1 is the ‘ String’, and B1 is ‘ string’ then result of the EXACT function will be FALSE
The following method shows how to compare text in excel.
#TEXT COMPARE ONLINE FULL#
Excel functions, formula, charts, formatting creating excel dashboard & othersĪs Excel is versatile, there are several ways to compare the text, like full compare or a part of that text, where we can use other functions in Excel (LEFT, RIGHT, INDEX, MATCH, etc.).