Hi,

Give us more examples.
With given examples, use one of the following formulas:

=SUBSTITUTE(RIGHT(A1,LEN(A1)-FIND("-",A1)+1),"^","")
or
=SUBSTITUTE(RIGHT(A1,5),"^","")