If you like, send the workbook to me and I will sort it
and return it to you. Remove XXX from my email address.

http://www.officeletter.com/blink/specialsort.html
--
Jim Cone
San Francisco, USA
XX



"justaMom"
wrote in message
...
I have an Excel spreadsheet that contains 4,000 names and addresses of local
registered voters. The addresses are listed with the house number and street
(102 Oak Ave., eg) I want to sort the data so that all the people living on
the same street are together. Is there any way to do that in Excel, and if
not, is it possible to export the spreadsheet to Access and do it there. I
have tried several times to read the spreadsheet in as an Access data base,
but no luck. But I don't know if it is possible to do that even if I could
get the data base set up. Anyone got any suggestions?