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
Solved! Go to Solution.
@tww
Did you include the 1 in your formula?
@tww Your Contains() function syntax is not correct it should be the other way around Contains([String],'text')