Regex Splitter

how do I Split this cell:

Text, Text2: Numbers Text3: Number Text5 (Zusätzliche Faser für PON), Text 6 Text7: NumberVNumbers Text8 Text9: Adress

Into this cells:

Text2: Numbers
Text3: Numbers
Text5 with all Words
Text 6 Text 7 NumberVNumbers
Text8 Text 9 Adress

Thank you for your support!

Can you formulate in plain words the rules that govern this split? For example, the first “Text” is its own line, but the last one between “Text8” and “9” does not get its own line. Why?
Kind regards,

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.