» Return text up to the second space in Microsoft Excel
CATEGORY - Working with Formulas , Excel Text Formulas
VERSION - All Microsoft Excel Versions
Text : George W. Bush The Function:
=LEFT(A5,FIND("*",SUBSTITUTE(A5," ","*",LEN(A5)-LEN(SUBSTITUTE(A5," ",""))))-1) Result: George W.
Book Store:
Recommended Books:
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- Keys to Reading an Annual Report (Barron's Business Keys)
- Accounting Principles, with CD, 6th Edition
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
- Excel 2002 For Dummies®
- Marketing Plans That Work, Targeting Growth and Profitability
No comments have been submitted.
