Below is a possible solution to the challenge – Challenge 34 – Increment All Digits by 7 and Perform Numerological Sum of the Digits.
=SUMPRODUCT((MOD((MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)+
7*ROW(INDIRECT("1:"&LEN(A1)))^0)-1,9)+1)*10^(LEN(A1)
-ROW(INDIRECT("1:"&LEN(A1)))))
The workbook containing the above solution can be downloaded from Solution – Challenge 34 – Increment All Digits by 7 and Perform Numerological Sum of the Digits.