you could go to Data|Text to Column and split the names into 2 columns
then you'll have col A first names, B last and just Sort by col B
hope this helps

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com