Can anyone please help and advise how can I sort the attached list both alphabetically and numerically. Have failed in my attempts and now need assistance.
I have a list of UK postcode sectors which I am trying to sort alphabetically and numerically, the order should be eg AB1 0, AB10 1, G2 1, G20 1 but excel wont allow that sort order.
There are three postcode formats
XX11 1
X1 1
X11 1
where X an Y could be any letters in the alphabet and 1 could be any digit 0 to 9.
Have attached a short list and would be grateful if someone could help with a formula in column B which would allow me to sort the list in column A which I can
then apply to my full list.
Thanks
MikeyM
Bookmarks