Insert each line in a new row
 

Try Data/Text To columns.... comma delimited.
Copy columns one under the other then sort to get rid of blanks.


--
BrianB


------------------------------------------------------------------------
BrianB's Profile: http://www.excelforum.com/member.php...info&userid=55
View this thread: http://www.excelforum.com/showthread...hreadid=373516