Extract last numbers in a column of varying lengths/formats

I am looking to refine my current formula that extracts all digits from the values in column A. The values varying in length and format, but I want to just refine the formula I currently have.

current formula in column B:

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(MID(A5,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A5&"0123456789")),FIND(" ",A5&" ",MIN(FIND({0,1,2,3,4,5,6,7,8,9},A5&"0123456789")))-MIN(FIND({0,1,2,3,4,5,6,7,8,9},A5&"0123456789"))),"$",""),"%",""),",","")

Desired result in Column C:

Product	                                Criteria 1	Desired Result
Pontiac $500-$20	                  500-20	    20
Feet $500-$40	                          500-40	    40
USA Feet $2,000-100%	                  2000-100	    100
USA Feet $2,000-100% Gt Plus	          2000-100	    100
Orange $3,000-70% Treat ACE Free	  3000-70	    70
USA Emboss. Orange $3,000-80%	          3000-80	    80
USA Emboss. Orange $4,000-100%	          4000-100          100
USA Emboss. Orange $4,000-100% Gt Plus	  4000-100	    100