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)

Комментарии • 3

  • @patrickschardt7724
    @patrickschardt7724 26 дней назад

    Thanks for another great leason

  • @دراساتاجتماعية-ز9ل
    @دراساتاجتماعية-ز9ل 29 дней назад

    Thank you

  • @ohdjrp4
    @ohdjrp4 26 дней назад

    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.