use the text to column tool


use the other section (after pressing the next button) to put the " - "
in and hey presto, they are split...

HTH


--
mr_ben
------------------------------------------------------------------------
mr_ben's Profile: http://www.excelforum.com/member.php...o&userid=37106
View this thread: http://www.excelforum.com/showthread...hreadid=568449