|Assuming that the parts numbers that are embedded in the string are always preceded by a "semicolon space"|
then try this:
With your data in cell A1
do a Text To Columns to split the string at the semi-colon
into three seperate cells
This is for 2007:
Highlight cell A1
On the ribbon select the DATA tab
Select Text to Columns
select the Delimited button
From the list of Delimiters, check Semicolon
You should now have three cells, A1, B1, C1
with your seperated data and
each cell should begin with your part number.
Now in cell D1 enter the formula:
=LEFT(A1,FIND(" ",TRIM(A1),1))&", "&LEFT(B1,FIND(" ",TRIM(B1),1))&", "&LEFT(C1,FIND(" ",TRIM(C1),1))
In essence it is the same formula repeated three times and
concatenates the three cells A1, B1, C1 together seperated
by a comma.
See how that works for you.