Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to sort addresses in microsoft excel
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to sort addresses in microsoft excel
On Jul 17, 11:00*pm, recrit wrote:
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 to clarify, i25 was the cell containing the address in my test case |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sort mailing addresses in Excel? | Excel Discussion (Misc queries) | |||
How do I sort addresses in excel? | Excel Worksheet Functions | |||
how can I use my e-mail addresses on excel xp with microsoft outlo | Excel Discussion (Misc queries) | |||
how can I use my e-mail addresses on excel xp with microsoft outlo | Excel Discussion (Misc queries) | |||
how can I use my e-mail addresses on excel xp with microsoft outlo | Excel Discussion (Misc queries) |