» Extract the last word in a cell in Microsoft Excel
CATEGORY - Excel Text , Excel Formula
VERSION - All Microsoft Excel Versions
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?
Book Store:
Recommended Books:
- Financial Statement Analysis with S&P insert card
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- Marketing Plans That Work, Targeting Growth and Profitability
- Seven Habits Of Highly Effective People
- Analysis of Financial Statements
- Wall Street Journal Guide to Understanding Money and Investing
No comments have been submitted.
