Forum Discussion

Richard028's avatar
Richard028
Copper Contributor
Jan 09, 2019

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

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!

Resources