Question on "contains" function

[tww]

Hi all,

I have following text strings, and I would like to get all the ones contain "text" (case insensitive). I tried Filter with "Contains("text",[String]) but it did not show the correct results. Could someone help and let me know why ? Thank you

String

Text A

A

Text B

Text c

Txt C

text C

B

Output

String

Text A

Text B

Text c

text C

TWW

[Qiu · Accepted solution]

@tww 
Did you include the 1 in your formula?

[binuacs]

@tww Your Contains() function syntax is not  correct it should be the other way around Contains([String],'text')

[tww]

Thank you, @Qiu  and @binuacs .