Seperate First Last name from single cell

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I have a list of names and thier whole name is in a single
cell in the following format: LastNM, FirstNM How can
I seperate the last name and first name into seperate
columns and cells?
 
A1 -> cell with names in it
B1 -> =LEFT(A1,FIND(", ",A1,1)-1)
C1 -> =MID(A1,FIND(", ",A1,1)+2,LEN(A1))

Frank's does better with errors
 
Here's one of many ways;

Name in A1
Last name:
B1 =LEFT(A1,FIND(",",A1)-1)
First name:
C1 =RIGHT(A1,FIND(",",A1)-2)
 
IF you want to do without formulas, select the column, Go
to Data/Text to Column/ Select Delimited, then Next.
Select Other and type "," in the box beside it(no quotes).
Finish.
 
Back
Top