Seperate First Last name from single cell

[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?

 

[Frank Kabel]

Hi
have a look at
http://www.cpearson.com/excel/FirstLast.htm

 

[jamesglewisf]

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

 

[Dave R.]

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)

 

[Guest]

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.