Select the whole range of data, (columns A and B, and as many rows as
applicable).

Data/ Sort/ Sort by (Column B) then by (Column A).
--
David Biddulph

"Curtis Stevens" wrote in message
...
A1 = Street number like 1234
B1 = Street name like lake wood drive

I want all records to be sorted by street name (B1) and then the records
with identical street names, to be sorted by their numbers, A1.

Thanks!
Curtis