Filtering question

[brierrose]

I want to filter on only a small part of the text in a column. As an example
I want to filter on “CTâ€. When I use an auto filter and do contains “CTâ€, I
get unwanted items. I want CTL BR CARROT CT F but I don’t want CTL BR CARROT
WH F or CTL BR CARROT CHIP F. I need to be able to put spaces before and
after the “CTâ€. Does anyone have any ideas?

 

[Peo Sjoblom]

You can type in whatever you want in the custom filtering, you don't need to
select from the dropdown.

--


Regards,


Peo Sjoblom

 

[Sheeloo]

Try * CT *
i.e * followed by space then CT again space and then *

 

[brierrose]

That worked great.
thanks,

Try * CT *
i.e * followed by space then CT again space and then *