Sorting UK Postcodes
Hi David
Create a helper column with the formula
=LEFT(A1,2)&TEXT(MID(A1,3,2),"00")
Copy down for the extent of your data.
Copy the whole helper column, Paste SpecialValues
Sort the whole block of data using the helper column
--
Regards
Roger Govier
"Aristobulus" wrote in message
...
I need to relaibly sort UK postcodes in a column
e.g. the codes BS1 0IAA, BS23 3EB, BS2 3XX, BS10 5GT
I need to sort codes as BS1.. BS2... BS3... not BS1... BS10... BS2...
--
David Green, UK
|