Highlight the name column and split it into two columns (selecting
datatext to columns). Choose delimited data and select 'space' as the
delimiter.

Sort both columns by surname and then merge the two back together
(Although I'd leave them separate to avoid the same problem).

Garry


--
sevil_gp
------------------------------------------------------------------------
sevil_gp's Profile: http://www.excelforum.com/member.php...o&userid=27905
View this thread: http://www.excelforum.com/showthread...hreadid=474048