one way, if they are all in one column is to select the range (single
column) and choose, data, text to columns, and choose the appropriate
break.

a formula to do it would use the find and left or right functions.


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=492163