Extract Last Two Words of a string

hi,

i need to extract only last two words of string in excel. Currently i am using the following function to do so. But unfortunately, its not extracting for all the strings. Majority of the strings i didnt get the results while for very few of them got the result. Can you please help why is this happening?

=TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",60)),120))

I have attached file where i have shown the result set. Also i have highlighted which one is correct and which one is not.

Thanks in advance for your help.

Thanks,
Vijay