Edxcel Spreadsheet Help please :)

[MrBlobby]

Hi please help.
i I want to convert a binary output into letters, where each column refers to a letter. so 111 would be LMN and 101 would be LN, 10111111111101 would be ACDEFGHIJKLN is this possible ? Thanks

 

[darkgen]

Not sure I understand the ask. This would convert an alphanumeric into binary; in this instance whatever is in cell A

=TEXTJOIN("",TRUE,DEC2BIN(CODE(MID(A1,ROW(INDIRECT("1:" & LEN(A1))),1))))

Ensure you create an array, so hold down Shift + CTRL when hitting Enter.
Converts each alphanumeric in cell A1 into binary.

darkgen
1100100110000111100101101011110011111001011101110

Requires Office365; Gleaned from another site.

E: eh after some verification; I'm not convinced it does even that!
E: it's omitting the preceding zeroes in each block!