Last challenge was about giving a non-array formula for Sum of Square of the Digits in a Numeric String. Now, the challenge is for an alphanumeric string. This time, there is no restriction that you need to give only non-array formula only. You may give array formula also.
Let's say cell A1 contains an alphanumeric string. The challenge before you is to give me a formula to sum the square of the digits.
As an example if A1=a3c78q90A6, then answer would be
Note – You may choose to post the response in comments section.