To overcome these kinds of scenarios, we can apply the formula with the TRIM function, which removes all the unwanted space characters. As we can see, there is one trailing space character entered after the word “Delhi”, which is contributing as an extra character.In cell A9, we have 9 characters, but in cell B9, we have ten characters, i.e., one extra character in cell B9.Let’s apply the LEN function in excel for each cell, which tells the number of characters in the selected cell.By just looking at the data, we cannot really tell what the difference is we need to go minute analysis mode. This is an extreme case but a real-time example. In cell A9 and B9, we have the same value as “New Delhi”, but still, we got the result as FALSE. So both are different, and obviously, the result is FALSE. Cell C7: In A7 cell, we have “Bangalor”, and in cell B7, we have “Bengaluru”. Here the difference is we don’t have space characters after the word “New”. Cell C3: In A3 cell, we have “New York”, and in B3 cell, we have “NewYork”. In some cells, we got the result as FALSE (colored cells), which means Source 1 data is not equal to Source 2. Drag the formula to the remaining cells to get the result.If Source 1 is equal to Source 2, we will get the result as TRUE or else FALSE. Since we are matching Source 1 = Source 2, let’s select the formula as A2 = B2.SUM, COUNT, COUNTA, COUNTBLANK, AVERAGE, MIN Excel, MAX Excel, LEN Excel, TRIM Excel, IF Excel are the top ten excel formulas and functions. read more The term "basic excel formula" refers to the general functions used in Microsoft Excel to do simple calculations such as addition, average, and comparison. This can be done by simple basic excel formulas The term "basic excel formula" refers to the general functions used in Microsoft Excel to do simple calculations such as addition, average, and comparison. We have city names from two different sources we need to match whether Source 1 data is equal to Source 2 or not.The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. The cookie is used to store the user consent for the cookies in the category "Performance". This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
The cookie is used to store the user consent for the cookies in the category "Other. The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional". The cookie is used to store the user consent for the cookies in the category "Analytics".
These cookies ensure basic functionalities and security features of the website, anonymously. Necessary cookies are absolutely essential for the website to function properly.