We actually did find some VBA code that does the trick. It's just that in
this particular case, we really, really want to use a formula.

Thank you.

"Peo Sjoblom" wrote:

You'd need VBA for that

http://tinyurl.com/53p5b


Regards,

Peo Sjoblom

"RJF" wrote:

My colleague has a problem where he needs to Extract numbers from
alphanumberic strings. Here is the formula he is using:
=MID(B7,MATCH(TRUE,ISNUMBER(1*MID(B7,ROW($1:$297), 1)),0),COUNT(1*MID(B7,ROW($1:$297),1)))

It works if alphabetic and numbers are clustered together such as scs987
It works if alphabetic and numbers are not clustered together such as
scs987dtg

Problem: It does not work when numbers are not clustered together such as
scs987dtg1234

Any suggestions would be helpful.

Thank you.