Text to columns.

[danielsffs]

Hello everyone,

I'm faily new to Excel and I am creating a simple encrypter in Excel. I want to seperate some binary digits using Convert text to columns wizard but the binary string I am refering to is shown as the formula I used. How can I separate the binary code? I added a screenshot explaining the situation. Thanks in advance.

Greetings Daniël 

[#2 · Accepted solution]

@danielsffs 

Why not use a formula? With 365

= LET(
  start, SEQUENCE(1,12,1,8),
  MID(permutation,start,8))

 or without

= MID(permutation,{1,9,17,25,33,41,49,57,65,73,81,89},8)

[#3]

Thanks, I ended up doing this:
=LEFT(B19)
=MID(B19;9;8)
=MID(B19;17;8)
=MID(B19;25;8)
=MID(B19;33;8)
=MID(B19;41;8)
=MID(B19;49;8)
=MID(B19;57;8)
=MID(B19;65;8)
=MID(B19;73;8)
=MID(B19;81;8)
=MID(B19;89;8)

Your solution looks more elegant. But as a novice I am content with this. Have a good day!