Wildcard characters only work with text values. The easiest way I can think
would be to create a helper column with:
=--RIGHT(A2,1)
copied down, and then have the Advanced Filter search on with a criteria of
just 2.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"ajayb" wrote:

Hi all,

I have a column of staff numbers like so:

30002042
30002026
30002072
30002070
30002094
30002008
30002022
30002018
30002099
30002031
30002062

When I try to find all staff whose number ends in 2, my *2 wildcard criteria
is retirning no records. I have tried formatting the range to number,
general and text to no avail! Can anyone tell me what I'm missing here?

Many thanks

Andy