» 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:
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
- Analyzing Markets, Products, and Marketing Plans
- The Basics of Finance: Financial Tools for Non Financial Managers
- Special Edition Using Microsoft Outlook 2002
- Marketing Plans
- How to Use Financial Statements: A Guide to Understanding the Numbers
Extract the last word in a cell in Microsoft Excel
rami
=RIGHT(A1,LEN(A1)-FIND("*",SUBSTITUTE(A1," ","*",LEN(A1)-LEN(SUBSTITUTE(A1," ","")))))
