» 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:
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- Microsoft Access 2002 for Dummies
- Word 2002: The Complete Reference
- Managerial Accounting: Tools for Business Decision Making, WebCT, 2nd Edition
- Treason: Liberal Treachery from the Cold War to the War on Terrorism
- Finance and Accounting for Nonfinancial Managers
No comments have been submitted.
