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
>Solution :
try:
=FLATTEN(SPLIT(REGEXREPLACE(A2; "(.{6})"; "$1"); ""))
