In the opening Formula Helper dialog box please do as follows.

Find text in excel sheet formula. Create one column header for the SEARCH result to show the function result in the C column. But COUNTIF does the job well if apple is found it returns 1 if not it returns zero. Then select Formulas and check Errors.

Click on the C2 cell and apply the SEARCH Formula. The syntax of the Excel Find function is as follows. When the text is not found FIND returns a VALUE error.

Another way with COUNTIF. To check if a cell contains specific text you can use the SEARCH function together with the ISNUMBER function. The Formula for the FIND function is as follows.

Go To Special. In the generic version substring is the specific text you are looking for and text represents text in the cell you are testing. 1048576 C4 Now COUNTIF will count cells with the substring John anywhere in the cell.

How to Search Text in Excel. First prepare an excel sheet with the required details in it. FIND and FINDB locate one text string within a second text string and return the number of the starting position of the first text string from the first character of the second text string.

In the example shown the formula in C5 is. The first two arguments are mandatory. 2 Click to select Count the number of a word in the Choose a formula list box.