Regex Splitter

Hello,
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:

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

Thank you for your support!

Hi,
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,
Alexander

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