Separate Values and Text in Power Query

I recently received a question asking how to separate values and text, especially when there is no common delimiter such as a space separating them.

Quelle: Separate Values and Text in Power Query