» Extract the first word in a cell in Microsoft Excel
CATEGORY - Excel Text , Excel Formula
VERSION - All Microsoft Excel Versions
Enter the following text in cell A1: Are you going to Disneyland?
Use the following function:
=IF(ISERR(FIND(" ",A1)),A1,LEFT(A1,FIND(" ",A1)-1))
The result: Are
Book Store:
Recommended Books:
- Microsoft Office XP Step-By-Step (With CD-ROM)
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
- Now, Discover Your Strengths
- Microsoft Windows XP Inside Out
- MP Managerial Accounting w/ Topic Tackler, Net Tutor, & PowerWeb
No comments have been submitted.

