Choose Data Tab
then "text to columns"
then "deliminited"
click next
then chose "space"
click finish

that will seperate each word into it's own column

then you should be able to do any type of sorting from there


--
mikecookaxa
------------------------------------------------------------------------
mikecookaxa's Profile: http://www.excelforum.com/member.php...o&userid=27926
View this thread: http://www.excelforum.com/showthread...hreadid=500291