ISNUMBER function checks if the output is number or not. Let’s try to remove this error with the help of the ISNUMBER function. Now, we have used IF and FIND in combinations the cell with no string still gives #VALUE! error. Step 7: Drag the formula from cell B2 until cell B4. Press Enter after editing the formula with IF condition.Īfter using the above formula, the output is shown below. One of the condition is TRUE, the other if the condition is FALSE. Once you use FIND under IF as a condition, you need to provide two possible outputs. Step 6: In order to get a customized result under column B, use the IF function and apply FIND under it. I mean, someone might not be good enough in excel to understand the fact that 1 appearing in cell B2 is nothing but the position of the word “Excel” in string occupied in cell A2. This, however, doesn’t always provide a clearer picture. In cell B3 the word is not present hence the formula is providing the #VALUE! error. You can see in the screenshot above that the mentioned string is present in two cells (A2 and A3). Step 5: Drag the formula to see the position where Excel belongs under cell A3 and A4. If you can see, this function just returned the position where the word “Excel” is present in the current cell (i.e. Step 4: Close the parentheses to complete the formula and press Enter Key. We are going to ignore the start_num argument as it is an optional argument. Therefore, choose A2 as the next argument to FIND function. Step 3: We want to find whether “Excel” is present in cell A2 under a given worksheet.

How to search a page for certain text