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)