Excel 2007 : Advanced text to column data manipulation

Hi there,

I have tried looking for an answer on the forums but couldn’t find anything. I don’t have much excel knowledge, just the basics.

I have a single cell of product specification data that I would like to separate into multiple columns, basically listing the product specifications in their own columns

The problems when doing a text to column filter I face are:

1. Although the different specifications are generally separated by commas, there are errors where the comma hasn’t been inserted at time of capture resulting in 2 specifications occupying the same cell.
2. Sometimes a comma has been used within a certain specification instead of a period resulting in one specification separated into multiple cells.
3. Not all product specifications are the same. i.e some products will have one specification but not another and/or there are different values associated with each specification.

How does one consolidate the data solving 1 and 2
How does one sort the relevant specification so they get inserted in the correct column? There are keywords which can be used as an identifier.

I have attached a worksheet showing examples and issues

Any help would be greatly appreciated
Thanks
~W