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
"text."

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?

One way:

=--COUNTIF(A1,"*Houston*")

In article
<82505b17-58c3-455c-8e6b-5477abd836fa@e39g2000hsf.googlegroups.com>,
TiChNi <tcnichols@gmail.com> wrote:

> 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
> "text."
>
> 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?

Another way:

=IF(ISNUMBER(SEARCH("Houston",A1)),"yes","no")

SEARCH is not case sensitive - use FIND instead if you need this.

Hope this helps.

Pete

On May 2, 10:50*pm, TiChNi <tcnich...@gmail.com> wrote:
> 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
> "text."
>
> 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?