Excel Challenge 1 in Excel Fundamentals & help forums Posted October 2, 2022 · Edited October 2, 2022 by Mbuyiselo Ntandoyenkosi Xaba Assuming the first number 456 is in cell A2 =SUMPRODUCT(MID(A2, ROW(OFFSET(&A$1,,,(LEN(A2))),1)+0)
Excel Challenge 1
in Excel Fundamentals & help forums
Posted · Edited by Mbuyiselo Ntandoyenkosi Xaba
Assuming the first number 456 is in cell A2
=SUMPRODUCT(MID(A2, ROW(OFFSET(&A$1,,,(LEN(A2))),1)+0)