Forum Discussion
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 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
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)
2 Replies
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)- 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!
