One way:

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

HTH,
Paul

--

"USA" wrote in message
...
I need help spliting a cell with a formula after a character.
this is the result i need 80

problem result
90-80 80

the number on the right is different in lengh, 2 number or 5 number to the
right of "_"