» Separating First and Last Names Using Formulas
CATEGORY - Excel Editing
VERSION - All Microsoft Excel Versions
To separate the name John Smith, in cell A1, use two formulas:The formula that extracts the first name is:
=LEFT(A1,FIND(" ",A1))
The formula that extracts the last name is:
=MID(A1,FIND(" ",A1)+1,LEN(A1))
The FIND formula returns the starting position of one text string within another text string.
Book Store:
Recommended Books:
- Guide to Financial Reporting and Analysis
- Microsoft Access 2002 for Dummies
- Business Analysis and Valuation: Using Financial Statements, Text and Cases
- Microsoft Excel 2002 Simply Visual
- The Total Money Makeover. : A Proven Plan for Financial Fitness
- The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition
No comments have been submitted.
