How do I list postcodes in order in Excel?
I think the only way is to transform yor postcodes column with this formula
in a helper column:
=LEFT(A2,2)&TEXT(MID(A2,3,255),"00")
and sort by this new column.
Regards,
Stefi
€žjillysillybilly€ť ezt Ă*rta:
I have a list in Excel that I need to sort by postcodes, but in its current
format, the postcodes (Column A) go like this, eg: BA1 then BA10 BA11 BA12
etc then BA2, but I want them to go BA1 BA2 BA3 etc. How do I do this?
|