Good day

I came across a formula that can extract numbers from a mixed string on ExtendOffice.

https://www.extendoffice.com/documen...om-string.html

=SUMPRODUCT(MID(0&A5, LARGE(INDEX(ISNUMBER(--MID(A5, ROW(INDIRECT("1:"&LEN(A5))), 1)) * ROW(INDIRECT("1:"&LEN(A5))), 0), ROW(INDIRECT("1:"&LEN(A5))))+1, 1) * 10^ROW(INDIRECT("1:"&LEN(A5)))/10)

Although the formula works, I can't make heads or tails of how it works.

If anyone can shed a little light on this I would really appreciate it.

Thanks