Hi

This comes close, but not quite there. It doesn't replace any missing descriptions and the butter item seems to have a slightly different construct.
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B2,") [",")|"),"] (","|"),"g carb)",""),", ", "^")
To get closer, and with the different constructs, you may have to go to a VBA solution (in the form of a UDF).

Is this a viable option? If so, can you attach an example file with multiple examples that cover the situations you meet, and the expected output for them.

rylo