Hello,
I see the below formula to separate number and text. I understand in general that it 1) check each character in the text and takes out only the numbers 2) 10^ that number by its position 3) Finally sumproduct to sum up all these number together.
However, I could not understand in detail how each inside formula works. Could you help me please? Thank you so much.
=SUMPRODUCT(MID(0&A22,LARGE(INDEX(ISNUMBER(--MID(A22,ROW(INDIRECT("1:"&LEN(A22))),1))*ROW(INDIRECT("1:"&LEN(A22))),0),ROW(INDIRECT("1:"&LEN(A22))))+1,1)*10^ROW(INDIRECT("1:"&LEN(A22))))/10
Bookmarks