A quick Excel function of getting 2 last words in a cell with IF function

Job ID: 36731002

Budget: ₹400 – ₹750 INR

We are looking for someone who is proficient in Microsoft Excel to help us with a quick project. We need an Excel function that can extract the last two words in a cell and use the IF function.
A quick Excel function of getting 2 last words in a cell with IF function (IF the last word is ANH, then get 2 last words, if not get 1 last word)
And how to fix the display font Unicode UTF-8 in Excel - Vietnamese - in PROPER function.
It may take just a couple of minutes, you need to send me the function and record in Loom for explanation.