» Separating First and Last Names Using Formulas
CATEGORY - Excel Editing
VERSION - All Microsoft Excel Versions
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:
- Advanced modelling in finance using Excel and VBA
- The Accounting Game : Basic Accounting Fresh from the Lemonade Stand
- Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports
- Microsoft Word Version 2002 Step By Step (With CD-ROM)
- Now, Discover Your Strengths
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
No comments have been submitted.
