Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting street addresses
Here's my dilema: I have spreasheet full of addresses. I'd like to sort the
street address column by street name, however the column includes both the street number and street address. Any idea how to do that? Here's a sample of my spreadsheet: 1975 Glenada Cres 351 Glenashton Dr 2012 Grand Blvd 2135 Pineview Dr 2154 Pinevalley Cres 1017 Glenbrook Ave 1057 Glenbrook Ave 134 Glenashton Dr 1442 Creekwood Trail 1558 Lancaster Dr 2015 Grand Blvd 2027 Highridge Crt 1356 Summerhill Cres 2204 Golden Briar Trail 1542 Lancaster Dr 2012 Grand Blvd 1414 Bayshire Dr 1550 Lancaster Dr 1486 Grand Blvd 1480 Grand Blvd 2124 Pineview Dr 2121 Pinevalley Cres 1580 Lancaster Dr 1102 Grandeur Cres Thanks, Marta |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help! How to sort addresses by street then by #...... | New Users to Excel | |||
Sorting IP Addresses in Excel? | Excel Discussion (Misc queries) | |||
sorting IP addresses | Excel Discussion (Misc queries) | |||
Working with street addresses? | Excel Discussion (Misc queries) | |||
Problems copying street addresses and dates | Excel Discussion (Misc queries) |