Curtis Stevens wrote:
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!
Hi Curtis,

Sorting is straightforward, but only if your data is "well-structured".

The most important things for "well-structured" data are

a) Your columns have labels in the first row (e.g., "street number" and
"street name" in row 1)

b) Your rows do not have breaks. I.e., *no blank rows anywhere between
data rows*.

c) Your columns do not have breaks. As in b), do not allow blank columns
to separate your data.

Points b) and c) are particularly important, for different reasons.

Anyway, if you have data that is "well-structured" according to my
definitions, all you need to do is

Put cursor anywhere in the data
Pick Data | Sort
In the Sort dialog,
choose "Street Name" as the first sort
choose "Street Number" as the second sort
click OK

Let's see how that works... Hope you do not have a mix of numeric and
alphanumeric data in "Street number".