I need these uk postcodes split out by county
In column B for example the first case says "Altens, Aberdeen city" - Altens is the "town" and Aberdeen city is the "county"
I want the "county" to be the subject so i can sort by county as well as "town"
So you will need to create 2 new columns;-
1. column to enable me to sort by town
2. column to enable me to sort by county