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.
Hi Hans,
You're a genius!! This is exactly what I needed and wanted.
I'm now going to study the formulas used to see if I can discover how they work.
I'm very grateful!!
Many regards
You're a genius!! This is exactly what I needed and wanted.
I'm now going to study the formulas used to see if I can discover how they work.
I'm very grateful!!
Many regards
Some time ago, I came up with a method to generate those often needed 4-digit codes we might need for such things as bike locks. I'm sure now, with the advent of, and my better understanding of, some of the newer functions, I could make this work more elegantly. Unlike the cyphers you were looking for, this does not necessarily generate unique codes for any given word; that wasn't my goal, which was to just come up with a code based on a word I could associate with the application. BIKE, therefore, becomes 2-9-2-5, and if it's been a long time since I last used my bike, I can quickly reconstruct the code.
My approach is a bit less straight forward than your second one, so a bit less "crack-able." Essentially, I reduce every letter to a single digit. The number 7 represents G, the 7th letter, and Q, the 16th, and Y, the 25th. T, the 19th letter becomes 10, which becomes 1.
But I love what HansVogelaar did with your request. He's a superstar in these parts.