Hi which formular to use to pick up the last word from right end?

601 St Kilda Road Suncorp/ AAMI Level GD Melbourne
Inala Avenue Inala Plaza Shopping Centre Shop C7(B)&C8, Inala,
Coles Liquor Group Liquorland North Lakes 1 Macmillans Road North Lakes