Certainly there is a simple way to find out if a cell that has text in
it contains a certain word. For example, cell A1 is populated with
the words "Houston, TX, USA." In Cell A2 I want a function that can
look into A1 to see if the word "Houston" is contained in there. If
it is, I would have the function return a value or some other
If only there were a symbol for "contains" if would be a breeze.
=If(A1[symbol]"Houston",1,0). Who has the answer to this?