if i understand you correctly you have one collumn in your spreadsheet
which contains data you wish to split into 2 columns

what I have done in this situation is copy the offending column to
another spreadsheet. save as CSV file and open in notepad.

one opened in notepad you can use the "replace" option

replace " " with ","

save the sheet and open in excel and copy the 2 new columns back into
the orgional spreadsheet.

hope that helps


--
jmw
------------------------------------------------------------------------
jmw's Profile: http://www.excelforum.com/member.php...o&userid=31636
View this thread: http://www.excelforum.com/showthread...hreadid=512463