Thread: In Excel how do you rearrange a list of address's in alphaetical o
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme[_2_] Bernard Liengme[_2_] is offline
external usenet poster
  
Posts: 563
Default In Excel how do you rearrange a list of address's in alphaetical o
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?

Reply With QuoteReply With Quote