» 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:
- Adventure Capitalist: The Ultimate Road Trip
- The 22 Immutable Laws of Branding
- Windows XP for Dummies
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
- How to Use Financial Statements: A Guide to Understanding the Numbers
- Mastering Excel 2000 (for beginner)
oioio
oioio
oioi
[SOLVED] Summing a number representing time with a time value.
Hemmo
...you could use'Text to Columns...'
Or...
Hemmo
...you could use'Text to Columns...'
Separating First and Last Names
rscott7706
Text to columns for a first and last name is a great solution as long as you clean out any residual spaces.
But how do we handle the following:
John Smith
Paula A. Green
John Paul Jones
Jeff John Paul Thomas
The last example is somewhat extreme (and for this conversation could be ignored), but not out of the realm of imagination.
How do we get three columns from a three part name?
:)
TExt to Column command
Julius Biliran
Well, the easier solution could just have been using the "text to column" function.Click on Data menu, and click on Text to Columns. It is really great!
