![Search column for text excel](https://kumkoniak.com/90.jpg)
![search column for text excel search column for text excel](https://www.edutechional.com/wp-content/uploads/2018/06/Snip20180606_15-1500x844.png)
These two are similar for computing tools. Yes, they are almost the same, the only difference is the case. For you, word Play and play can be the same thing. The most frequent differences we have noticed among the texts are case sensibility. While finding text that is similar to the measuring text you need to keep in mind that it may not be exactly the same at times. Finding Similar Text in Two Columns Using the SEARCH Function This is a basic scenario to show you examples, in practical life, you may encounter many complex scenarios as well as a large data set.
![search column for text excel search column for text excel](https://www.techonthenet.com/excel/macros/images/search_for_string2_001.png)
We will find the similarity between the elements of the columns. To keep things simple we have selected a basic table of two columns Student Name and Summary. But before diving into the big picture, let’s get to know about the Excel book which is going to be our base of examples for today. Now, we will discuss 3 effective ways to find similar text in two columns in excel. 3 Easy Ways to Find Similar Text in Two Columns
![Search column for text excel](https://kumkoniak.com/90.jpg)