![]() ![]() 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |