Excel Question: How can I take firstname, lastname in one column and separate into two columns?
Excel Question: How can I take firstname, lastname in one column and separate into two columns?
Observing members:
0
Composing members:
0
3 Answers
Assuming you have a space or comma between the first and last names, you can use Data / Text to Columns. (I’m still using Excel 2000, so your commands on a more recent version may be different, but the functionality should still be there.)
Unless all of your Firstname Lastname combinations are the same length, then choose “Delimited” and select your delimiting character/s, such as “space”, or comma, or whatever it is.
The text will be broken into separate columns automatically.
Assuming your full name column starts at cell A1 and the names are separated by a comma and a space as in your example, you could use the following formulas and fill down. You can also replace the comma in the quotation marks with a space or any other character separating the first and last names, assuming it is a unique character within the cell.
first name column: =LEFT(A1, FIND(”,”,A1) – 1)
last name column: =RIGHT(A1, LEN(A1)-FIND(”,”,A1) – 1)
Answer this question
This question is in the General Section. Responses must be helpful and on-topic.