Could you post a few columns and rows of your data for us to peruse.

Don't post a file unless you want to use one of the Internet sites.

Use either of the 2 free filehosts below to upload a sample of your actual
worksheet.
(Desensitize it first, if needed). Then copy & paste the generated link to
your sample file in response he

http://www.flypicture.com/
http://cjoint.com/index.php


Gord

On Wed, 26 Sep 2007 16:56:00 -0700, lifeworksla
wrote:

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