extract number after dash

[L.LEE]

Hi

Could you pls help me with the formula to extract the number "1" after the dash from data such as:
Yearly {Long-Term Debt} (1996) - 1
Yearly {Interest Income} (1996) - 1

thanks

[FDibbins]

Maybe this?
If there will only ever be 1 digit...
=right(a1,1)

if there will be more than 1 digit...
=MID(a1,FIND(" -",a1)+3,99)

[FDibbins]

Happy to help and thanks for the feedback