Data Sort Function Problem

  • Thread starter Thread starter andyp161
  • Start date Start date
A

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
 
With the post code in say D2 you could use
=LEFT(D2,2) in an adjacent empty column and sort by that column,
Regards,
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert Zip codes into weather code 5
Compare 2 Worksheets and return differences in a third. 4
Automatically sorting data 4
copy Data selection from one workshhet into an existing worksheet 2
bug in excel 2007 for sorting function? 3
MultiSelect ListBox Help 2
Returning varying rows of data through lookup function 1
Sort two tables of data 10

Back
Top