» Extract the last word in a cell in Microsoft Excel
CATEGORY - Excel Text , Excel Formula
VERSION - All Microsoft Excel Versions
Use the Following Function:
=RIGHT(A1,LEN(A1)-FIND("*",SUBSTITUTE(A1," ","*",LEN(A1)-LEN(SUBSTITUTE(A1," ","")))))
The result: Disneyland?
Book Store:
Recommended Books:
- Treason: Liberal Treachery from the Cold War to the War on Terrorism
- Word 2002: The Complete Reference
- Microsoft Outlook Version 2002 Step by Step (With CD-ROM)
- Harry Potter and the Order of the Phoenix (Book 5)
- The Accounting Game : Basic Accounting Fresh from the Lemonade Stand
- MP Managerial Accounting w/ Topic Tackler, Net Tutor, & PowerWeb
Extract the last word in a cell in Microsoft Excel
rami
=RIGHT(A1,LEN(A1)-FIND("*",SUBSTITUTE(A1," ","*",LEN(A1)-LEN(SUBSTITUTE(A1," ","")))))
