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
I took a little while to upgrade every so slightly the way the spreadsheet works, and added a second tab with a visible and easy way to come up with ever more difficult to crack codes.
- Thanks for your reply Mathetes, I like what you've done and I think I will be able to use it for something else I'm working on!
- Hi Mathetes, thank you for your latest message. I just love anything that introduces cyphers etc. to youngsters - and I'm thinking your work puts another version/method my way that I can work on. I'm also trying to learn some of the more 'unusual' functions/formulas in Excel, and finding out much more just how useful Excel is at all sorts of things other than just spreadsheets - which is all I've ever really used it for in the past.