This is time for a cryptography challenge. The simplest cipher in cryptography is Caesar's Shift. More about this can be read here (though it will not be needed for this challenge) – https://en.wikipedia.org/wiki/Caesar_cipher
For a given alphabet, it simply substitutes by another alphabet by a fixed number of position. Hence, if shift position is 5, a will be f, A will be F, M will be R, x will be c, Z will be E.
Now challenge before you is to write a formula to achieve the same. The result should be case sensitive.
Hence, you will put the Shift in cell B3 and the answer would be expected in column H for column D.
The workbook related to this challenge can be downloaded from Challenge 39 – Caesar's Shift Cipher
The answer to this puzzle will be published after a month i.e. on 26-Apr-16.