Solution – Challenge 39 – Cryptography Challenge 1 – Caesar’s Shift Cipher

Below is a possible solution to the challenge Challenge 39 – Cryptography Challenge 1 – Caesar’s Shift Cipher.

Put below formula in G2 and drag down –

=IFERROR(CHAR(IF(CODE(LOWER(D2))+$B$3>122,CODE(D2)+$B$3-26,
CODE(D2)+$B$3)),"")

The workbook containing the solution can be downloaded from Solution – Challenge 39 – Caesar's Shift Cipher.