I personally prefer Gord's suggestion, but just as an alternative,........in
a helper column put........

=MID(A1,FIND(" ",A1,1)+1,99)

Vaya con Dios,
Chuck, CABGx3




"Chuck Davis" <newsgroup at anthemwebs dot com wrote in message
...
I have an excel worksheet with addresses in the form of "1234 Some St."
I would like to sort by street name.

Any solution?

Thanks in advance