Excel - Separating text with numbers text and brackets into separate cells

Question

Is it possible to separate the following text into separate cells: To separate four cells, what would be the first DBL Del (103), second DBL Del (200), third DBL Del (150), and so on? Text and numbers can both be different, but in general, the number denotes how often the text should be repeated and should be given a consecutive number from a bracket. Additionally, there may be additional text following a comma, such as 3 TPL Sup (120, 230, 102) and 2 SGL St. (227, 234)

Answer 1

You can try FILTERXML().