No the problem is the data I want to sort the column by is contained within
the address - it is not the lead part of the data
Col B has the full list of the suburbs that I am trying to d the sort with
The data in col. B does not form a part of the record for each line
Thanks
Stephen


"ozgrid.com" wrote in message
...
I'm assuming you have blanks in Column "B" representing repeated Suburbs.
http://www.ozgrid.com/Excel/excel-fill-blank-cells.htm





--
Regards
Dave Hawley
www.ozgrid.com
"Father John" wrote in message
...
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