Hi
try the following array formula (entered with CTRL+SHIFT+ENTER):
=SUM((--MID(0&A1,LARGE(IF(ISNUMBER(-MID(0&A1,seq,1)),seq,1),seq),1))*10
^(seq-1))

where seq is a defined name with the formula
seq: =ROW(INDIRECT("1:255"))

Not sure about the originator of this formula. My guess would be Harlan
or Aladin?

--
Regards
Frank Kabel
Frankfurt, Germany

"Mira" schrieb im Newsbeitrag
...
Is there a formula that will pull the numbers only from
the letters and numbers mixed in?
Example: D16M644HGUD


Thank you!