![]() ![]() Instead of numbers, we can enter the result in our own words as well.We can see the error value of #VALUE! in the cell B2 that shows that the cell A2 doesn’t have the text value “best”. So, in two sentences, we have the word “best”. The last parameter is not required to close the bracket and hit the enter key.Within Text, select the full sentence, i.e., cell reference.In the Find Text argument, mention the text that we need to find.Now in each cell, we need to search for the text “Best”. In the above data, we have three sentences in three different rows.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |