Sorting multiple piece data

[Odepust]

I have addresses that I would like to sort but I would like to Sort them by the street name and not the number that precedes it.

Ex:
5 Sunset Gr
12 Fox St
33 Hemmings St
5 Everitt St
35 David St
1458 Heatherton Rd

Into

35 David St
5 Everitt St
12 Fox St
1458 Heatherton Rd
33 Hemmings St
5 Sunset Gr

I've tried changing all variables to text and to try and create a custom sort but none work so far. All the options for sort come out with each being sorted by the number and not the text. All the Data is in a single column which makes a bit harder.

[DonkeyOte]

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.