CONTAINSSTRING is a function, verifying, whether there is some textstring. CONTAINSSTRINGEXACT works similarly but is case sensitive.

It is simple. If there is “small pink pig” in column Item, then this:

  • Contains pig = CONTAINSSTRING(List1[Animal];"pig")

returns True. On the other hand this:

  • Contains frog = CONTAINSSTRING(List1[Animal];"frog")

returns False.

These functions are quite missing in Excel (outside DAX), where have to be replaced by complicated combination like:

  • =LEN(A1)-LEN(SUBSTITUTE(A1;"pig";""))

Leave a Reply

Your email address will not be published.

*

clear formPost comment