Can I create a custom formula field that searches for text contained in another text field (not a picklist)?  We have a custom text field in our acount records that contains a long string of text (list of products that are updated in batch each night).  

I would like to create a sperate field that indicates if the first text field has 1 of 6 different words in it (they are specific products).

I can do this easily in excel but cannot figure out how to do it here.  The Contains argument is only for a picklist, yes?    Thanks, in advance, for you input.

Can I create a custom formula field that searches for text contained in another text field (not a picklist)?  We have a custom text field in our acount records that contains a long string of text (list of products that are updated in batch each night).  

I would like to create a sperate field that indicates if the first text field has 1 of 6 different words in it (they are specific products).

I can do this easily in excel but cannot figure out how to do it here.  The Contains argument is only for a picklist, yes?    Thanks, in advance, for you input.