Using Excel To Decrypt ROT

Anya has made us a scavenger hunt complete with clues — clues that are encrypted! While working out a ROT-1 or ROT-2 decryption isn’t terribly difficult, it was getting a little time consuming [especially when what was advertised as ROT-1 was actually ROT-(25) and I had to do it all over again!], so I made a quick spreadsheet to decrypt strings. The letter pairs are in the first two columns, then VLOOKUP is used to convert the printed character to the actual one. I found a trick card!

Leave a Reply

Your email address will not be published. Required fields are marked *