do you want to separate the words first??
if so,
got to data=text to columns= select delimited then next select comma
then select finish,
the words will seperate. besure not to have any info to the right of
the coplumn because it will write over what you have if you let it,
once you have the infor seperated you will have no prblem sorting it
--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile:
http://www.excelforum.com/member.php...o&userid=31708
View this thread:
http://www.excelforum.com/showthread...hreadid=517921