Excel 2007 : tricky issue with sorting

[FinnyTheGoose]

I could really use your help.

I have a list of names and addresses, but the addresses are all in "1234 street name" format, meaning that there's a number followed by a name (rather than say "1234 98th st").

The problem is that there are multiple addresses on the same street, but they're not together I need to group them together.

So if I have say,

1142 Alhambra Circle
1981 Granada Blvd
2286 Alhambra Circle

How can I assure that all of the entries with the same street NAME are together?

[Andy Pope]

User a helper column, which contains the address with the digits removed, to sort.

=MID(A2,FIND(" ",A2)+1,LEN(A2))

will return text to the right of the first space.

[FinnyTheGoose]

you are the best thank you!