Hi
If you always have a "-" character before the text bit and your text is
in A2 then try

=Trim(RIGHT(A2,LEN(A2)-FIND("-",A2)))

This finds the postion of the "-", subtracts it from the length of the
text (so that is the length of the word you want), then extracts that
much text from the right hand side of the whole string. The trim deals
with any blank space lying about.
regards
Paul