CONTAINS

[Johmz]

hi,

I need help to create formula to identify column that contains valid code IMAGE*:ORIG. e.g IMAGE1:ORIG, IMAGE2:ORIG 

Sample column

[CPacheco89]

Hello all,

I have a similar problem but regarding multiple criteria. I'm trying to figure out how to filter out the data based on multiple keywords using the contains formula. In this example, I'm looking for any of the cells that contain the text of contacted, features, or listened. I don't have the text analytics features, so I'm hoping there is a way to pull fields with the keywords via a formula. Any insight would be greatly appreciated. 

Sample column

[alexnajm · Accepted solution]

Contains[field],"contacted") OR Contains[field],"features") OR .... and so on

[CPacheco89]

Flawless! Thank you!