View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Ryan Bob Ryan is offline
external usenet poster
 
Posts: 8
Default 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.