title: How to get last word in a cell using Excel Formula
body: <p>I am trying to get the last word in a cell however, it does not seem to be appearing getting the last word of the cell.  It seems to get the partial match and not working correctly. I am using <code>=IFERROR(RIGHT(AP2,SEARCH(" ",AP2)-1),AP2)</code>.  This works great for getting the first word in a cell even where the first word is the only word in a cell.  Any ideas on why this is not getting the last word correctly? <a href="https://i.stack.imgur.com/KGcUu.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/KGcUu.png" alt="enter image description here"></a></p>