For this, we need to use the IF condition. Instead of numbers, we can enter the result in our own words as well.So, in two sentences, we have the word “best.” 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.” The last parameter is not required to close the bracket and hit the enter key.For instance, if we have data in cell A2 and want to use that in cell A1, use =A2 in cell A1, and this will copy the A2 value in A1. Within Text, select the full sentence, i.e., cell reference Cell Reference Cell reference in excel is referring the other cells to a cell to use its values or properties.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.” So apply the FIND function. In the above data, we have three sentences in three different rows.
