The following long formula can help you to extract only the numbers from
the text strings, please do as this:
the text strings, please do as this:
Select a blank cell where you want to output the extracted number, then
type this formula:
type this formula:
=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)
and then drag the fill handle to fill the range you need to apply this
formula. See screenshot:
formula. See screenshot:
