Forum Discussion
Solved
Creating/generating simple codes (cyphers) for kids using Excel
Hi, Is it possible to use Excel to create simple codes (cyphers) for kids? I have three ‘codes’ in mind: An alpha code (where the letters are transposed with the letter before) such as A = Z, D...
See the attached demo.
In C1:
=TEXTJOIN("-",TRUE,CHAR(LET(c, CODE(MID(UPPER(A1),SEQUENCE(LEN(A1)),1))-1, IF(c=64,90,c))))
In E1:
=TEXTJOIN("-",TRUE,SORTBY(MID(UPPER(A1),SEQUENCE(LEN(A1)),1),RANDARRAY(LEN(A1))))
Thanks again, Hans. I feel like a total idiot - I didn't remove CONCAT when I added TEXTJOIN! It seems so obvious now.
Thanks again.
Thanks again.