In Excel how do you rearrange a list of address's in alphaetical o

I have 165 address's on a spreadsheet which using the post codes i wish to
put into alphabeticval order, how do i acheive this function?

Are the parts of the address in separate cells? And you you have headers?
A B C
D
Street Town Province Pcode
100 Main Street Sometown NS B3J A1D

If so, select any cell in the data and use Data Sort and use Pcode as the
major sorting 'key'
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme


"josstex" wrote in message
...
I have 165 address's on a spreadsheet which using the post codes i wish to
put into alphabeticval order, how do i acheive this function?

If the addresses are in a row culminating with the postcode a simple sort
will suffice.
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"josstex" wrote:

I have 165 address's on a spreadsheet which using the post codes i wish to
put into alphabeticval order, how do i acheive this function?

On 5/8/2010 2:40 PM, Bernard Liengme wrote:
Are the parts of the address in separate cells? And you you have headers?
A B C D
Street Town Province Pcode
100 Main Street Sometown NS B3J A1D

If so, select any cell in the data and use Data Sort and use Pcode as
the major sorting 'key'
best wishes

If each entire address is in it's own cell, you can use Data Text to
Columns to break the data into separate columns.