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.
For example:
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(UPPER(A1),"A",""),"E",""),"I",""),"O",""),"U","")
Thank you so much Hans I've now discovered another function I didn't know about - and by following your formula, I have some idea of how to use it, Thanks again - you're a hero!
Regards,
Les King
Regards,
Les King