Hi guys, first time here, hope someone can help.

I had a sheet that had names entered in column A, going in order of
surname, eg:
John Adams
Simon Allison
James Baker
Tessa Cunningham
etc...

I messed up a sort and then sorted by column A again to get it back in
alphabetical order, forgetting it would sort by the first names! So now
it reads:

James Baker
John Adams
Simon Allison
Tessa Cunningham.

Does anyone know how i can sort it back by the second word in Column
A??


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