Bob Phillips wrote:
You could extract the components then sort by these

E.g

=LEFT(A1),1
=MID(A1,2,2)
That doesn't work for postcode with a 2 character Area part (e.g. SW1A 4AA)