» 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:
- Financial Statement Analysis with S&P insert card
- Millionaire Real Estate Mentor : The Secrets of Financial Freedom through Real Estate Investing
- Microsoft Windows XP Inside Out
- Windows XP Pocket Reference
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
- Seven Habits Of Highly Effective People
oioio
oioio
oioi
Or...
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!
