How Extract Number after last "-"?

[ldiaz]

hello, I have a problem making some calculations.

I need to extract the number after the last "-", could you please help me on
this?
SAF-FIT-120 (120)
ABA-FIT-81 (81)
POUCH-120 (120)
TACT-16 (16)
TOC-39 (39)
ACCY-240 (240)
ETC-110 (110)

Thanks in advanced.

 

[Albert D. Kallal]

Try:

str = "lsjf-234"

Debug.Print Mid(str, InStrRev(str, "-") + 1)

 

[ldiaz]

Got it,

Thanks a lot
LD