Forum Discussion
Richard028
Jan 09, 2019Copper Contributor
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!
- Make sure to post this in the excel forum as well!!
Adam- Richard028Copper ContributorThanks for the remark.
This helped to solve my issue (via Excel Forum) :-)
Regards Richardgreat to help out :)
Adam