=mid(a1,column(a1,1)

in B1 and copy across

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jeff" <Jeff @discussions.microsoft.com wrote in message
...
I knew that Lotus 1-2-3 has Parse function but not sure if Excel has
similar
function too. Thanks.