Hides_Twins wrote:
help!

I have a column which lists the firstname, a space, then the surname.
ie. Joe Bloggs

I need to sort by SURNAME, then by firstname.

Can this be done without separating the names into different cells?

Hi Hides_Twins

Why can't you split the names into two different columns? Your Excel
life would be much, much simpler if you did.

Regards

Steve