Forum Discussion

Birann's avatar
Birann
Copper Contributor
Jan 22, 2020

Excel Question

So I have this idea to make a password encryption tool which would allow you to write down a sentance word for word. It would take each first letter of this word and change this alphabetically.

 

Example you have a code which is 4024

and a sentence with 4 words

of each word the 1st letter would be picked

example: The cow couldn't fly

 

Tccf

 

the code would add 4 alphabetical letters to each letter then 0 then 2 then 4. So it would look like this

 

Xcej

 

But if you would change the code to 8214 the "Tccf" would be different then with a code of 4024

 

I would like to know it its possible to add alphabetical letters like that.

1 Reply

  • mathetes's avatar
    mathetes
    Silver Contributor

    Birann 

     

    You write, I would like to know it its possible to add alphabetical letters like that.

     

    The answer is "Yes"

     

    Now the ball is back in your court. It'll be a good learning experience for you.

     

    By the way, not to burst your balloon, but I doubt a good cryptographer would have much difficulty decrypting a message encoded that way.

     

    On the other hand, I use an even simpler encoding method to generate 4 digit codes for all sorts of things. It's fun to do, but I don't fool myself about it being unbreakable. It's just a neat and not totally obvious way to have a code that works for me for my bike lock, say; but I wouldn't lock my bank account with it.  And no, it's not A=1, B=2, C=3 etc.

Resources