How to split Number in googlesheet

Question

Hello I would like to ask how to split this number 122426122427122428122429122430122441 into six digit numbers and put it to rows in google sheets.

How is it possible do this?
Thank you

I tried split functions but i did not find any positions function

doubleunary · Accepted Answer · 2022-12-27 17:19:24Z

1

Use byrow(), sequence() and mid(), like this:

=byrow( 
  sequence(len(A2) / 6, 1, 1, 6), 
  lambda( 
    start, 
    mid(A2, start, 6) 
  ) 
)

answered Dec 27, 2022 at 17:19

doubleunary

22k13 gold badges38 silver badges86 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

player0 · Accepted Answer · 2022-12-27 18:58:20Z

0

try:

=FLATTEN(SPLIT(REGEXREPLACE(A2&""; "(.{6})"; "$1"); ""))

answered Dec 27, 2022 at 17:21

player0

131k14 gold badges92 silver badges149 bronze badges