Check out the FIND() and SEARCH() functions. Then you could write an
IF() in A1 that says 'if the result of the FIND is greater than zero,
write "apple" in A1'.