» 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:
- What the IRS Doesn't Want You to Know: A Cpa Reveals the Tricks of the Trade
- Microsoft Excel 2002 Formulas (With CD-ROM)
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
- Microsoft Excel Version 2002 Step by Step
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- The Sweet Potato Queens' Big-Ass Cookbook and Financial Planner
No comments have been submitted.
