Contains Formula

Hey Guys,

Does anyone know if the Contains expression can be used to identified multiple text values in a column?

For example, I want to filter the rows that contain the text value Coke or Coca-Cola.

Thanks,
Bruno

No. Use 2 CONTAINS(), along with:

1 Like

Thanks Marc,

I created a slice where I used the Contains formula but I don’t know how to use along with OR(). Can I use the OR formula on Slice along with Contains or should I add the formula somewhere else?

Bruno

In same place:

OR( CONTAINS(…) , CONTAINS(…) )

3 Likes

AMAZING MARC :smiley:

Thanks, it’s working now!

1 Like