I have a column to which I want to apply an Auto Filter. The problem is
some of the cells in that column contain multiple values (for example
one cell contains "Screw & Housing"). When I select "Screw" from the
filter menu, it will only show the cells for which the value = "screw".
Is there a way for me to change the Auto Filter menu show that all the
cells that contain "screw" are shown.

I know it's possible to do this by selecting "Custom...", but I want
this to be directly available in the Auto Filter menu so that the
spreadsheet is user friendly.

Thank you,

Ed


--
braabe01
------------------------------------------------------------------------
braabe01's Profile: http://www.excelforum.com/member.php...o&userid=36364
View this thread: http://www.excelforum.com/showthread...hreadid=561510