Hi, I have a list of post codes two letter starts by region. e.g.
inner london:
EC
WC
SW
W
NW
E
SE
In addition I have several very long lists of postcodes which I can obviously pull out the first two letters from using the Left function.
However I am wondering what is the best way to filter the column of postcodes into the postcode defined regions such as inner london nicely.
Any help is greatly appreciated,
Thanks
Bookmarks