» 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:
- Analyzing Markets, Products, and Marketing Plans
- Excel Charts
- The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- How to Use Financial Statements: A Guide to Understanding the Numbers
- The Intelligent Investor: The Classic Bestseller on Value Investing
No comments have been submitted.
