I did that, it still doesn't sort the first three columns.

"Gord Dibben" wrote:

Don't let Excel guess.

Select all the columns in your data range before sorting on the address column.


Gord Dibben MS Excel MVP