We made ourselves familiarized with Caesar's Shift in last challenge – Challenge 39 – Cryptography Challenge 1 – Caesar's Shift Cipher
That challenge was for writing a formula to perform Caesar's Shift on a single alphabet. But now, we need to have a fully functional Caesar's Shift Cipher.
The challenge before you is to write a VBA function which takes cell or text as first argument and amount of shift as second argument to generate the Cipher Text.
Hence, to generate answer in A2, we have called the function as =EncryptCS(A1,B2)
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 answer to this challenge would be published after a month i.e. on 09-May-16.