How to check if Excel cells contain partial text

July 26, 2022
10.6K Views
0

A free Office suite fully compatible with Microsoft Office

Free Download

To check if a cell includes a particular piece of partial text, use the Excel formula below:

=IF(COUNTIF(A1,*abc*),Yes,No).

In this example, cell A1 will return a Yes if the string abc appears anywhere in the cell, and a No otherwise.

To illustrate all the strategies, we will use a sample product pricing list as the data set in this post. Let's take a quick look at the data set now

So let's jump right into each strategy one at a time without more debate.


Check to see whether the Beginning of the Text Is Included in excel online, 2016 and 2019


The steps listed below can be used to find a partial match at the start of your texts:

1.To store the output of the formula, choose cell E5.Now, type the formula.=IF(COUNTIF(B5,MTT*),Yes,No)

2.Then press the Enter button.



3.The Fill Handle indicator should now be moved to the last row of the Partial Text column.



4.When you have completed all of the aforementioned procedures, the formula's output will look like the image below:



Check to See whether the End of a Partial Text Contains in excel

1.If you want to explore the partial text that is there at the end of the text, you can follow the instructions below.To store the output of the formula, choose cell E5.Add the formula:=IF(COUNTIF(B5,*NPP),Yes,No)

2.Press the Enter button.



3.The Fill Handle indicator should now be moved to the last row of the Partial Text column.When you have completed all of the aforementioned procedures, the formula's output will look like the image below:



Verify if any position in the partial text contains in excel

1.You can follow these steps to conduct a blind search across the entire dataset, looking for a partial match at any position:To store the output of the formula, choose cell E5.Now type the formula:=IF(COUNTIF(B5,*NQ*),Yes,No)

2.Press the Enter button.



3.The Fill Handle indicator should now be moved to the last row of the Partial Text column.



Note: This above written article is an attempt to show you how excel cells contain partial text online, 2016 and 2019. This above stated method of explaining you how excel cells contain partial text, can be applied in windows and mac both, so if you have any of these, you can apply this method on both of them.You just need to have a little understanding of how and which way things work and you are good to go with your work. With having this basic knowledge or information of how to use it, you can also access and use different other options on excel or spreadsheet. Also, it is very similar to Word or Document. So, in a way, if you learn one thing, like Excel, you can automatically learn how to use Word as well because both of them are very similar in so many ways. If you want to know more about WPS Office, you can download WPS Office to access, Word, Excel, PowerPoint for free.