Hi folks - been lurking here anonymously a while.

Gotta stumper I can't see solved anywhere else.

Trying to filter out any address line 1 values in this spreadsheet that DON'T begin with a street number (for obvious reasons - they're bogus/unusable)/

I tried adding a multi-row advanced filter criteria set to exclude any value that doesn't begin with 1, 2, 3, 4, 5, 6, 7 or 9:

<>1*
<>2*
<>3*

etc.

Weird results - one criteria (e.g. just the <>1* works fine).

Trying to use all 9 criteria does nothing.

Here's the file
data_test.xls

Help?