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 ***
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Forum Rules
Bookmarks