Removing non #'s from cell (letters, - , #, etc)

[Craig92604]

I need to remove all non- numbers from cells. I know there is a way to do this but my brain is fried today

 

[Aladin Akyurek]

=SUBSTITUTE(AB13485,RIGHT(AB13485,SUMPRODUCT((LEN(AB13485)-LEN(SUBSTITUTE(AB13485,{0,1,2,3,4,5,6,7,8,9},""))))),"")

Didn't quite work for instance:

77R5158 = 7 WANTED: 775158

A-054-4M = A-05 WANTED: 544

76DB2408 =76 WANTED: 762408

?

That formula is meant for input like either

LLLDDDD

or

DDDLLLL

and not for

DLLLDL

LLDDDLLD

LLDDLLL

etc.