» Separating First and Last Names
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
Separating the full names in column A into first and last names in columns B and C.
Solution:
To retrieve the first name use the LEFT and FIND functions as shown in the following formula:
=LEFT(A2,FIND(" ",A2))
To retrieve the last name use the RIGHT, LEN, and FIND functions as shown in the following formula:
=RIGHT(A2,LEN(A2)-FIND(" ",A2))

Book Store:
Recommended Books:
- Yes, You Can Time the Market!
- Business Analysis and Valuation: Using Financial Statements, Text and Cases
- Keys to Reading an Annual Report (Barron's Business Keys)
- The Analysis and Use of Financial Statements
- Financial Peace: Revisited
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
No comments have been submitted.


