We made ourselves familiarized with Caesar's Shift in Challenge 39 – Cryptography Challenge 1 – Caesar's Shift Cipher and made its decrypter in Challenge 53 – Cryptography Challenge 4 – Caesar's Shift Cipher Decrypter. We also made a fully functional encrypter in Challenge 40 – Cryptography Challenge 2 – Fully Functional Caesar’s Shift Cipher based on VBA solution as formula based solution has its own limitation.
The challenge before you is to write a VBA function to create a fully functional Caesar's Shift Cipher Decrypter. This should take cell or text as first argument and amount of shift as second argument to generate the Decrypted Text.
Hence, to generate answer in A3, we have called the function as =DecryptCS(A2,C2)
Note – The shift is only for the English Alphabets and case sensitive. Any other character like comma, space etc. should appear as they are.
The Excel file related to this challenge can be downloaded from Challenge 56 – Cryptography Challenge 5 – Decryption – Fully Functional Caesar’s Shift Cipher
The answer to this challenge would be published after a month i.e. on 19-Dec-16.