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

J

josstex

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?
 
B

Bernard Liengme

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
 
B

Bob Ryan

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.
 

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

Top