filter not working
i have a Text column that is imported from a huge file, filtered down. i can not change it.
System column contains 123456z01, 123456n02, 123456.
i use the filter contain but it will not show "123456".
the only thing i can think of is that is is a number in a text field.
i looked at using contains in the filter and selection all that start with "123456", but some may have 15-20 lines to check.
is there another way that i can get the Contains "123456" to work?