Run two separate sorts: first sort the numbers then sort the names.
Portland, Oregon USA
Office Excel 2007
Second level sort not rendering
I have a name address etc wksht where the street number is one column
and the street name is another column
I set the first sort on street name and the second level sort to
street # .
The street name sorts fine but the street numbers do not order
correctly so that instead of getting 123 xyz st then 125 xyz st and
345 xyz st, the numerical part of the address is not sequential.