View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
recrit recrit is offline
external usenet poster
 
Posts: 20
Default how to sort addresses in microsoft excel

On Jul 17, 5:43*pm, GAW wrote:
I have 2 lists of addresses on one sheet. Most of the addresses are
duplicates and I want to sort them so it puts all the duplicates together..
The streets include the house number, as 1257 Rock St. I can sort them by
street alone but I need to sort by street and the address together, is there
a way to do this? I am using Excel 2000, * 9.0.2720.


if your address is always in the format of 1257 Rock. St, you can
split it into 2 columns, 1 for the number, 1 for the street
number =MID(I25, 1, SEARCH(" ", I25, 1)-1)
street =MID(I25, SEARCH(" ", I25, 1)+1, LEN(I25))

then use excel to sort by street column first, then by number column