Hi

I have a spreadsheet with numerous addresses in col. A 1-999

15 Smith Street Jonestown
21 George Street Blacktown etc.

In col B. 1-166 I have the name of all the suburbs in our region

How can is sort col. A by suburb using the name of the suburbs in Col.B. ?

Any help much appreciated

Regards
Stephen