据我所知，以下内容对我有用.

As far as I can tell the below worked for me.

=TRIM(RIGHT(SUBSTITUTE(AP40," ",REPT(" ",100)),100))

我只能假设我的另一种方法在获取最后一个单词时不可靠.

I can only assume my other method is unreliable at getting the last word.