Filtering UK Postcodes

Hi

I have hundreds of records which include postcode fields for the whole of the UK.

I need to filter this to show all entries for specific postcode areas. More specifically at postcode regions beginning -

BB, BL, M, OL, SK, DN, LN, S, WF

Ideally this filter should show the number that follows the first or second letter in the postcode as necessary. For example BB1, M3 etc.

I know there is a Left function but this would still show postcodes including MK, ML, SY and ST.

Can a numerical wildcard be added after the letter? That would eliminate the postcodes I don't want to see.

Thanks

Assuming postcode to check is in A2, try this one

Formula:

Please Login or Register  to view this content.

*** This is an array formula and must be confirmed with Shift Ctrl and Enter, not just Enter ***