Forum Discussion

Copper Contributor

Dec 23, 2021

Solved

Text to columns.

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 referin...

excel

Formulas and Functions

PeterBartholomew1

Dec 24, 2021

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)

PeterBartholomew1

Silver Contributor

Dec 24, 2021

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)

danielsffs

Copper Contributor

Dec 24, 2021

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!