A bit of a shot in the dark but I'm trying to sort records by the first part of a UK postcode and wonder if anyone has any shortcuts. I'm trying to sort them using VBA as it is a final part of a procedure.
This is an example of what I am looking for
AB1
AB2
AB3
AB10
AB12
AB20
B1
B2
CH1
CH2
CH11
I can seperate the numeric from the alpha part of the postcode but then require two columns to sort the data. Is it possible to sort the data in a single column.
thanks
Matt
This is an example of what I am looking for
AB1
AB2
AB3
AB10
AB12
AB20
B1
B2
CH1
CH2
CH11
I can seperate the numeric from the alpha part of the postcode but then require two columns to sort the data. Is it possible to sort the data in a single column.
thanks
Matt