Challenge 6 – Non-array Formula for Sum of Square of the Digits in a Numeric String Posted on December 13, 2014May 31, 2015 by Vijay A. Verma Let's say cell A1 contains a numeric string. The challenge before you is to give me a non-array formula to sum the square of the digits. As an example if A1=378906, then answer would be = 9+49+64+81+0+36 = 239 Note – You may choose to post the response in comments section.