» Extracting the First N Number of Words from a String
CATEGORY - Excel Text Formulas
VERSION - All Microsoft Excel Versions
Problem: 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:
- Financial Statement Analysis: A Practitioner's Guide, 3rd Edition
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- How to Use Financial Statements: A Guide to Understanding the Numbers
- PowerPoint® 2002 For Dummies®
- The 11 Immutable Laws of Internet Branding
- Analyzing Markets, Products, and Marketing Plans
No comments have been submitted.
