Splitting Text in Single Cell (1 Viewer)

[tmyers]

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 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.

 

[tmyers]

I completely overlooked the full function of TEXTSPLIT. Doing TEXTSPLIT(Text, "-", ",") actually splits it exactly as I was asking about.

 

[The_Doc_Man]

Thank you for posting the solution to your problem. It helps others who might be looking for a similar solution and thus is a welcome contribution to our forum!