Mbuyiselo Ntandoyenkosi Xaba
-
Posts
1 -
Joined
-
Last visited
Content Type
Profiles
Forums
Gallery
Downloads
Blogs
Events
Online Conference
The Excel dictionary
Power Query M function dictionary
Everything posted by Mbuyiselo Ntandoyenkosi Xaba
-
Excel Challenge 1
Mbuyiselo Ntandoyenkosi Xaba replied to Saurabh Jain's topic in Excel Fundamentals & help forums
Assuming the first number 456 is in cell A2 =SUMPRODUCT(MID(A2, ROW(OFFSET(&A$1,,,(LEN(A2))),1)+0)
