FIND and SEARCH locate text within a cell, with FIND being case-sensitive and SEARCH not. For example, =SEARCH("apple", A1) finds "apple" in A1.