» 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:
- Guide to Financial Reporting and Analysis
- Business Plans Kit for Dummies (With CD-ROM)
- Microsoft Office XP Step-By-Step (With CD-ROM)
- Millionaire Real Estate Mentor : The Secrets of Financial Freedom through Real Estate Investing
- Seven Habits Of Highly Effective People
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
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!
