how to trim the number next in dash sign

[kylechace]

hi please help. i need a formula to get the number next in - sign. below are the example.

1. 31-60 result should be 60
2. 121-150 result should be 150

thanks

[quekbc]

Try this?

Assuming the cells are in A1.

=VALUE(TRIM(RIGHT(A1, LEN(A1) - FIND("-",A1))))

[Root_]

Try this:

=--REPLACE(A1,1,FIND("-",A1),"")

[kylechace]

Thank you so much