To extract last 2 words, use below formula
=IF(ISNUMBER(FIND(" ",A2)),TRIM(RIGHT(SUBSTITUTE(A2," ",REPT(" ",LEN(A2))),2*LEN(A2))),"")
To make a generic formula, to extract last 2 words
=IF(COUNTIF(A2,"* *")>0,TRIM(RIGHT(SUBSTITUTE(A2," ",REPT(" ",LEN(A2))),2*LEN(A2))),"")
Now, you would need to change * * and 2 only which are marked in Red. If you need to replace last 3 words, then * * would be replaced with * * * and 2 with 3. Hence, formula would become
=IF(COUNTIF(A2,"* * *")>0,TRIM(RIGHT(SUBSTITUTE(A2," ",REPT(" ",LEN(A2))),3*LEN(A2))),"")
Hence, if you want to extract last word only
=IF(COUNTIF(A2,"*")>0,TRIM(RIGHT(SUBSTITUTE(A2," ",REPT(" ",LEN(A2))),1*LEN(A2))),"")
Note, actually for last word, simply use the second component of the formula (just to make it simpler)
=TRIM(RIGHT(SUBSTITUTE(A2," ",REPT(" ",LEN(A2))),1*LEN(A2)))
If you are not a fan of * * technique and want to replace numbers only, use below formula where 2 can be replaced with any number (2 is for extracting last 2 words)
=IF((LEN(A2)-LEN(SUBSTITUTE(A2," ","")))>=2-1,TRIM(RIGHT(SUBSTITUTE(A2," ",REPT(" ",LEN(A2))),2*LEN(A2))),"")