In this article, we will learn how to search a certain text using Excel functions.
If you need to find a text string, Excel if cell contains text. Use a combination of IFERROR, IF and SEARCH function in Excel 2016.
IFERROR function returns a custom result if an error occurs in the formula and a standard result when no error occurs.
|=IFERROR (value or formula, value_if_error)|
SEARCH function finds for a certain substring or value from the string or cell reference and returns the position of the first character of the certain text in the selected cell.
|=SEARCH (substring, string or cell reference, [start_num])|
IF function is one of the logical functions, to return one value if the condition is true and another value if it’s false.
|=IF(logical_test, [value_if_true], [value_if_false])|
Let’s look at this table below, here we took some strings. We need to find a certain substring in these.
Type the formula in the cell
SEARCH function searches for the substring in the cells.
IF function checks the cell value and if it finds the substring within text it returns True else False.
IFERROR catches any error and returns No as output
Copy the formula in other cells, select the cells taking the first cell where the formula is already applied, use shortcut key Ctrl+ D
As you can see the words which contain the substring, returns the substring or else it returns No.
Hope you learned how to search with the use of SEARCH, IF and IFERROR.You can perform these tasks in Excel 2013 and 2010. Find more articles on searching text here. Please do mention your views or questions below in the comment box. We will help you.
For more example click here
If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at firstname.lastname@example.org
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.