In Excel how do you rearrange a list of address's in alphaeticalo
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.
|