excel - Split very long number into six digit groups in separate cells -

423922479012375513457178457180550138521841520952496604498873488994376453521835559200448165554637498872457131510199376418546010374080492305457150455175473104455027541303457131512688454657473104448381453997477124499977406669541303375513490137467744460072532000492113454659402360422309528706455229453997375287375205404307422865375288528497547685445471533317543758522100377090491889524347364876492562454713532610477571550018492113476326403571354101377662432466457108540287544990374720522661431462550028539028434388489113495000402360404307522832548659490117548659552057542216534207470720492312510199527500457153477572402360402360465549408089494011431462376045490117556002541123552297548234406669461755451161469724374720521319436774354059490137376689417359354101440752422184427367490117402385457142549852372653523624522660405547376669462845376702489113521319523982458016550018456997376702552488552072549167490137454828376703457143457180547386442315457134552057376661376660432264371695552057526624457128403018490136548904521892375802490136402730522660540445464995479012531117490138490136377616544204542526533858540444522175457104548904376315364878548719467297457146540287550018490117544895541282477997374416510021552305496604

what function split 6 digits codes? mean break after each 6 characters column.

input huge number string cell, a1.

create column of numbers (1, 7, 13, ... , 1213) setting 1 , incrementing 6. column in range b3:b205.

now make column using function =mid($a$1,$b3,6) @ cell c3 , dragging c3 through c205.