» 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:
- Microsoft Access Version 2002 Step by Step
- Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business
- F1 Get the Most out of Excel! The Ultimate Excel tip Help Guide
- Accounting for Dummies
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- Investing for Dummies, Third Edition
No comments have been submitted.
