The FIND function in Excel is used to return the position of a specific character or substring within a text string.

Find text in excel sheet formula. FIND find_text within_text start_num The first 2 arguments are required the last one is optional. Lets look at a few methods. How to Search Text in Excel.

On your ribbons Home tab go to Find Select Go To Special. As you can see there is only one employee in XG department. When the text is not found FIND returns a VALUE error.

The syntax of the Excel Find function is as follows. The Excel FIND function returns the position as a number of one text string inside another. The first two arguments are mandatory.

To check if a cell contains specific text you can use the SEARCH function together with the ISNUMBER function. First prepare an excel sheet with the required details in it. You can also use SEARCH and FIND functions in combination to find the text substring from a given string.

Copy the formula to the rest of the cells using the Ctrl D or dragging it down from the right bottom tiny box of the applied cell. To search multiple worksheets in a workbook for a value and return a count you can use a formula based on the COUNTIF and INDIRECT functions. In the example shown the formula in C5 is.

In the opening Formula Helper dialog box please do as follows. The Formula for the FIND function is as follows. But COUNTIF does the job well if apple is found it returns 1 if not it returns zero.