I would create a sorter column and use the expression =iseven(cell
containing number) eg iseven(a2) and copy this down. You can then sort
by this column and then by the house number column.
You will still have problems if an address is:
a house name
a flat
of the form 24a
etc
As none of the above are numbers
Regards
Dav
--
Dav
------------------------------------------------------------------------
Dav's Profile:
http://www.excelforum.com/member.php...o&userid=27107
View this thread:
http://www.excelforum.com/showthread...hreadid=513522