Tip Printed from ExcelTip.com

---

Extract the last word in a cell in Microsoft Excel


Enter the following text in cell A1: Are you going to Disneyland?

Use the Following Function:
=RIGHT(A1,LEN(A1)-FIND("*",SUBSTITUTE(A1," ","*",LEN(A1)-LEN(SUBSTITUTE(A1," ","")))))

The result: Disneyland?