» Extracting the First N Number of Words from a String
CATEGORY - Excel Text Formulas
VERSION - All Microsoft Excel Versions
Extracting the first three words from each of the strings in column A.
Solution:
Use the TRIM, LEFT, FIND, and SUBSTITUTE functions as shown in the following formula:
=TRIM(LEFT(A2,FIND("^",SUBSTITUTE(TRIM(A2)&" "," ","^",3))-1))
Book Store:
Recommended Books:
- Business Plans Kit for Dummies (With CD-ROM)
- The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
- The Ernst & Young Business Plan Guide
- Good to Great: Why Some Companies Make the Leap... and Others Don't
- Microsoft Windows XP Step by Step (With CD-ROM)
- Seven Habits Of Highly Effective People
No comments have been submitted.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
