Whenever we prepare any report in excel, we have two constituents in any report.
The Text portion and the Numerical portion.
But just storing the text and numbers doesn’t make the super reports. Many times we need to automate the process in the reports to minimize the effort and improve the accuracy.
Many functions are provided by the Excel which work on Text and give us the useful output as well. But few problems are still left on which we need to apply some tricks with the available tools.
In this articles , we are going to find out the way to compare the two text strings in Excel.
The text string can be checked for the content only or content and case both.
What and What are exactly same in which the content and the case of both the words are exactly same.
If the words being compared are WHAT and What, the content of the words is same but the case is not same. We’ll discuss both the cases in this article.
TEXT IS AN INACTIVE NUMBER TYPE[FORMAT] IN EXCEL. ANYTHING STORED AS TEXT [NUMBER OR DATE] WON’T RESPOND TO ANY STANDARD FORMULAS OR FUNCTIONS BUT SPECIALLY DESIGNED TEXT FUNCTIONS. [EXCEPTIONS DO OCCUR IN CASE OF NUMBERS]
This situation can occur when we want to create some logical condition and check whether the two text strings are same or not.
Now the same can have two meanings.
1.Just the content is same. For example “TEXT” and “text”.
2. Exactly same [ Content is same and case is same]. For example, “teXT” and “teXT”
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE