Given the variability of your data, the only thing I will be able to do for the FILM TYPE (Column C) is give you all the text in front of the WIDTH number. About the WIDTH number... with one exception, it looks like all your WIDTH values have an "mm" after them. Again, because of the variability of your data, I will need that "mm" in order to locate the position of the WIDTH number, so I need to know about the exception. On Row 195, you have this...

CODE DESCRIPTION
250LM 250mc GLS 965 x 25m x 58mm

You are going to have to clarify this item for me and tell me if there are any other items like it. So, is the 965 the WIDTH value and the 25m the LENGTH value? If so, is this the only item in your full inventory of items that are possible to appear in the worksheet that does not have an "mm" after the WIDTH value? I ask because I will have to build an exception routine into the code to identify it, and all other items that are also missing the "mm" on the WIDTH value, so that I can pull out the correct numbers from the DESCRIPTION. On the other hand, if 965 is not the WIDTH value, then are the 25m and 58mm the LENGTH and WIDTH values (reversed from all the other items shown)? Remember, I have no familiarity with your data at all, so you will have to show me a list of all (what I will call) non-standard items for me (that is, items where the WIDTH does not have "mm" after it or where the LENGTH does not have "m" after ite or where the WIDTH comes after the LENGTH).