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.
Thanks for your most helpful earlier replies. I have now thought of another sort of cypher which I believe is probably possible to create using formulae in Excel.
I want to be able to type in a word (usually six or seven letters) into cell A1, and using a formula to show in cell B1 the word (with all the consonants in the same order as in the original word) with all its vowels removed. So if A1 = FREEDOM, B1 will be FRDM, and if A1 = BREAKER then B1 will be BRKR. Can anyone create a formula which will do this please? It's certainly way beyond my Excel skills (such as they are!)
Regards,
Les King
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