CODEWITHSUNDEEP
regexgoogle-sheetslambdasplitsequence
Rastislav Madac
Rastislav Madac

Reputation: 11

How to split Number in googlesheet

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

Upvotes: 0

Views: 423

Answers (2)

player0
player0

Reputation: 1

try:

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

enter image description here

Upvotes: 0

doubleunary
doubleunary

Reputation: 18819

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

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

Upvotes: 1

Related Questions