I am wanting to extract the colour code into a separate column from some product codes. The codes have slightly different lengths what I need to do is look at the code and after the second - pick the two next character from the product code.
Example spreadsheet of what I am after is attached or
BBB-G19-BE-L (returns BE)
DR-17-OL (returns OL)
ZZG-27-CH-S (returns CH)