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

Highlighted
Occasional Contributor

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!

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

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

great to help out  :)

 

Adam