Without using VBA I'd be inclined to split the numeric prefix and street name in adjacent columns so you can sort by both

Using your specific examples - if we assume the values are in A1 onwards

B1:
=0+LEFT(A1,FIND(" ",A1)-1)
copied down

C1:
=REPLACE(A1,1,FIND(" ",A1),"")
copied down

Now sort A:C by C & B in that order.