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

"brierrose" wrote:

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 dont 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?