View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
brierrose brierrose is offline
external usenet poster
 
Posts: 2
Default Filtering question

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?