You will need to separate the street number and street address into two
columns.

For street number: (say column B)

=left(A1,find( " ",A1)-1)

for street name: (say Column C)

=Mid(A1,find(" ",A1)+1,255)

Sort on column C and [then] B to get Street Name/Street Number sequence

HTH

"Marta" wrote:

Here's my dilema: I have spreasheet full of addresses. I'd like to sort the
street address column by street name, however the column includes both the
street number and street address. Any idea how to do that? Here's a sample
of my spreadsheet:

1975 Glenada Cres
351 Glenashton Dr
2012 Grand Blvd
2135 Pineview Dr
2154 Pinevalley Cres
1017 Glenbrook Ave
1057 Glenbrook Ave
134 Glenashton Dr
1442 Creekwood Trail
1558 Lancaster Dr
2015 Grand Blvd
2027 Highridge Crt
1356 Summerhill Cres
2204 Golden Briar Trail
1542 Lancaster Dr
2012 Grand Blvd
1414 Bayshire Dr
1550 Lancaster Dr
1486 Grand Blvd
1480 Grand Blvd
2124 Pineview Dr
2121 Pinevalley Cres
1580 Lancaster Dr
1102 Grandeur Cres

Thanks,
Marta