Hi
I have a large list of premises which has a column listing all their UK postcodes, ie HG2 0AG or B42 1EY etc etc. I would like to be able to sort the premises by the first letters of the postcode which will allow me to sort them into areas/regions, some have 2 letters and others just have a single letter. ie HG or B.
many thanks
Bookmarks