» 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:
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
- Word 2002: The Complete Reference
- Accounting and Financial Fundamentals for Nonfinancial Executives
- Now, Discover Your Strengths
- Financial Modeling - 2nd Edition
- Microsoft Office XP Introductory Concepts and Techniques
Extract the last word in a cell in Microsoft Excel
rami
=RIGHT(A1,LEN(A1)-FIND("*",SUBSTITUTE(A1," ","*",LEN(A1)-LEN(SUBSTITUTE(A1," ","")))))
