» Extract all the words except the first 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(" ",A1,1))
The result: you going to Disneyland?
Book Store:
Recommended Books:
- The Basics of Finance: Financial Tools for Non Financial Managers
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- Marketing Plans
- Now, Discover Your Strengths
- Real Estate Loopholes: Secrets of Successful Real Estate Investing
- Excel 2002 Power Programming with VBA
No comments have been submitted.
