Use Text to Columns. Select the cell you want to separate. Go to
Data/Text to Columns. Step 1 Delimited should be selected. Click Next.
Step 2. In the Delimeters select the check box next to semi-colon.
This will give you a preview of where the break will be. Click next.
Step 3, select the format. Click Finish.



HTH

Cheers,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=495530