Work with a copy before doing this:
Select the column and then on the menu bar select REPLACE:
In the FIND box - use the space bar and enter 1 space
In the REPLACE box - enter a comma.
Then do a replace all
This should replace all space between the names with a comma.
Now select the column and then go to the MENU Bar and Select DATA -
TEXT TO COLUMNS and follow the instructions.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=517485