I'm sure this can be done but is likely complicated to fully get what would be nice to have.
I have a cells filled with a list of material and quantity.
Example:
(4)-QO130L200PG, (4)-QO250, (4)-QO240, (16)-QO120, (24)-QO120PAFGF, (4)-QO200TR, (1)-QOM2100MVH, (12)-QO120PCAFI, (24)-QO115PCAFI, (12)-QO230, (4)-QOC30US, (1)-QO112L125PGRB, (4)-QOM2125MVH, (4)-QO1151021
I can use
I have a cells filled with a list of material and quantity.
Example:
(4)-QO130L200PG, (4)-QO250, (4)-QO240, (16)-QO120, (24)-QO120PAFGF, (4)-QO200TR, (1)-QOM2100MVH, (12)-QO120PCAFI, (24)-QO115PCAFI, (12)-QO230, (4)-QOC30US, (1)-QO112L125PGRB, (4)-QOM2125MVH, (4)-QO1151021
I can use
TEXTSPLIT(Text, ",")
to split the values across columns, but how hard would it be to break the quantities into a column then the part number into the next Column? It is not a big deal but would just be nice to do.