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.
See the attached demo.
Hi Hans, I have been trying to put the "-" delimiter into the other two results in cells C1 and E1 as that would work better for me. I have been trying to use the TEXTJOIN function with the two formulas you have provided, but I'm obviously doing something wrong and have given up after many tries. Can you help please - and when I see your formulas I can checkout why my efforts haven't worked. Thanks a lot.
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.