» 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:
- Final Accounting: Ambition, Greed and the Fall of Arthur Andersen
- The 11 Immutable Laws of Internet Branding
- Real Estate Loopholes: Secrets of Successful Real Estate Investing
- The Interpretation of Financial Statements
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
- Financial Peace: Revisited
No comments have been submitted.
