Why do you have so many blank rows in you data? that makes sorting difficult.

Having said that, you could add a couple of helper columns to separate Number and Street using TEXTBEFORE and TEXTAFTER then use the SORT & FILTER formulae to get your desired result. the helper columns (C & D) and columns H & I can be hidden.

Alternatively you could remove all the empty rows, add the helper columns as before, then sort first by Number then by Street. Again helper columns can be hidden or even deleted.

I agree with Charles but would add that you probably need to wrap the helper for the street number in a VALUE function. Otherwise the 'numbers' will be sorted as text. In case you have addresses like '98 Street' and '100 Street' you want to sort them in that order. Leaving the numbers as text will sort them "100" first, then "98".

Riny is correct, the TEXTBEFORE should be wrapped in VALUE. Thanks for pointing that out, Riny.

Hi,

Thanks for taking the time to answer my question.  

The blank line is there to make it easier to read while I am walking around trying to contact individuals. 

That was the last step in a long process of cleaning up some data, which Riny helped me previously.  After the "last step" I realized that the numbers were not in order.  Being lazy, I did not want to go back and sort by street then number, if that is possible (it was 2 different columns before joining).  

I'll start working on your solution today.

Again, thanks for all your help.

Cedric

Go back to having Number and Street in different columns. Much better that way.

You wrote:

"The blank line is there to make it easier to read while I am walking around trying to contact individuals. "

If you want more white space between the addresses, you could increase the row height. That's better than inserting blank rows.

Hi,

I believe Charles is right, I should have had two columns for address.  

I also, never thought of widening the rows, I'll try it out.  

Thanks again for taking time to help me out.  Keep up the good work.

Cedric