Need advice, formula problem - separate the last word in sentence ?

Hello !

I am beginner in excel formula. i please need some advice for this:

=IF(FIND("-";A1;1);SUBSTITUTE(A1;"-";" ";1)*AND(IF(ISERR(FIND(" ";A1));"";RIGHT(A1;LEN(A1)-FIND("*";SUBSTITUTE(A1;" ";"*";LEN(A1)-LEN(SUBSTITUTE(A1;" ";"")))))));"no")

If i have a sentence in cell i want the last word of this sentence, but it may happen that last and penultimate word are conect with "-"(dash).

On the net i found this formulas:
=IF(ISERR(FIND(" ";A9));"";RIGHT(A9;LEN(A9)-FIND("*";SUBSTITUTE(A9;" ";"*";LEN(A9)-LEN(SUBSTITUTE(A9;" ";""))))))
and
=TRIM(RIGHT(SUBSTITUTE(A7;" ";REPT(" ";LEN(A7)));LEN(A7)))
for split or separated last word in sentence from other text

then i found these:
=SUBSTITUTE(A15; "-"; " "; 1)
i need these because it cases when the last two words associated with "-"(dash) so I have to get rid of if I want the last word

and:
=IF(FIND("-";A15;1);"yes";"no")
that found me "-"(dash). i don't know if i need these

now i want all of these formula fusion together?

any ideas ?

Thank for help realy !
Have nice day !