In a Custom filter, for the first test enter:
Begins with: 18

Select OR as the operator
For the second test enter:
Contains: , 18

stremetzky wrote:
My cells include numbers in following format:

cell A1: 1, 14, 18, 34,
cell A2: 5, 22, 45,
cell A3: 1, 118, 150,
...

I want to filter cells to those which contain 18.
I use Autofilter, Custom, Contains, 18

But it doesn't filter A3, I guess because it contains 118. How can I
filter it to exact number?

stremetzky


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html