Array Formula ( Extract only Numeric from a string)


Here is a Array formula where A1 has alphanumeric value =SUM(INT(MID(A1,LARGE(–ISNUMBER(INT(MID(A1,ROW(INDIRECT(“1:”&LEN(A1))),1)))*ROW(INDIRECT(“1:”&LEN(A1))),ROW(INDIRECT(“1:”&SUM(–ISNUMBER(INT(MID(A1,ROW(INDIRECT(“1:”&LEN(A1))),1))))))),1)*10^ROW(INDIRECT(“1:”&SUM(–ISNUMBER(INT(MID(A1,ROW(INDIRECT(“1:”&LEN(A1))),1))))))))/10 Please share your idea to do the same.

Array Formula ( sum of digit in a cell)


Sum of Digit from a cell. Many time we need sum of Digit which are placed in a single cell, we can use this function to get desired result =SUM(INT(MID(A1,ROW(INDIRECT(“1:”&LEN(A1))),1))) As CSE (Ctrl+Shift+Enter)