Rather than do Text to Columns, then, can the data be split onto
separate rows, so that my first interpretation of what you require
would be valid?

If you are saying that there could be a variable number of colours
within these cells, then it will be very difficult to pick them out and
sum them in a single formula, though you could do it with a macro.

Is there always at least a single space after each close-bracket symbol
(except for the end)? We could then look for ") " to determine the
number of entries in each composite cell. Is there any restriction on
the number of columns we can use? If there are 4 entries we could use 4
adjacent cells for each number and another for the sum, so what is the
maximum number of different entries that you could expect in one of
these composite cells?

Could you tell me what SKUs are?

Pete