Excel 365: need to separate numbers and letters of one cell

[Richard028]

Hello

I have datas that are in one cell conbining letters and numbers. Now I like them separated in cells.

The sample of centent of cells is:

WABERN3084WERKSTRASSE20

BIRRWIL5708SCHWADERHOF3

WILA8492SCHOCHENSTRASSE7

AEGERTEN2558RAINSTRASSE2

ONEX1213ROUTDUGRANDLANCY166

ENTLEBUCH6162BLUMATTSTRASSE7

I like them automaticly sorten per cell as following (first cell):

Cell 1         Cell2     Cell3                   Cell4

WABERN    3084    WERKSTRASSE    20

Can anyone help?

Thanks a lot!

[#2]

Make sure to post this in the excel forum as well!!

Adam

[#3]

Thanks for the remark.
This helped to solve my issue (via Excel Forum) :)
Regards Richard

[#4]

great to help out  :)

Adam