» 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:
- Final Accounting: Ambition, Greed and the Fall of Arthur Andersen
- Microsoft Windows XP Step by Step (With CD-ROM)
- Microsoft PowerPoint Version 2002 Step by Step
- Financial Statement Analysis with S&P insert card
- The Intelligent Investor: The Classic Bestseller on Value Investing
- Guide to Financial Reporting and Analysis
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!
