How to split numbers into individual digits in excel
HTML-код
- Опубликовано: 3 окт 2024
- Separate numbers into individual cells
=FILTER(MID(B2,SEQUENCE(,LEN(B2)),1),MID(B2,SEQUENCE(,LEN(B2)),1) greater than less than ".")
=MID(SUBSTITUTE($B11,".",""),C$10,1)
Thanks for another great leason
Thank you
Hi, very nice tutorial! But how to separate into cells an integer numbers like 12, 1, 103...etc (Excel 2016) using formula?
With textsplit is easy but only available in 365 version.