If the First Name and the Surname are seperated by a space then if you
insert a blank column next to your name you can go to Data - Text to
Columns - Leave as Delimited and go to next - On the next screen ensure
Space is selected (with a tick) - Then click on Next - Then click on
Finish

This will split your data into two seperate columns with first name and
surname and will allow you to sort using the second column first and
then the first name.

Hope this does what you wanted?

Regards

Carl


--
mr_teacher
------------------------------------------------------------------------
mr_teacher's Profile: http://www.excelforum.com/member.php...o&userid=34352
View this thread: http://www.excelforum.com/showthread...hreadid=571883