Data Sort Function Problem

[andyp161]

Hi there,

I have to breakdown a mailing list on a worksheet into regions. Th
easiest way to do this is by post code (zip code). However, the are
identification of a post code is only the first two letters. Is ther
a quick way that I can list all post codes with area codes attached t
a particular region which does not involve listing in alphabetica
order, then manually allcoating all postcodes to their respectiv
regions??

Many thanks

And

 

[Alan]

With the post code in say D2 you could use
=LEFT(D2,2) in an adjacent empty column and sort by that column,
Regards,