LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 26
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help! How to sort addresses by street then by #...... HelpingOthersTD New Users to Excel 1 June 15th 06 09:29 AM
Sorting IP Addresses in Excel? Kris Excel Discussion (Misc queries) 3 May 2nd 06 12:07 PM
sorting IP addresses PattiTechWriter Excel Discussion (Misc queries) 3 December 6th 05 01:46 AM
Working with street addresses? Sully Excel Discussion (Misc queries) 1 February 16th 05 02:57 PM
Problems copying street addresses and dates C. Dales Excel Discussion (Misc queries) 4 February 11th 05 01:43 PM


All times are GMT +1. The time now is 09:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"