» 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:
- Getting to Yes: Negotiating Agreement Without Giving In
- Microsoft Excel VBA Programming for the Absolute Beginner
- The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition
- Windows XP All-in-One Desk Reference For Dummies
- Real Estate Finance and Investments (Real Estate Finance and Investments, 11th Ed)
- MP Managerial Accounting w/ Topic Tackler, Net Tutor, & PowerWeb
No comments have been submitted.
