What formula will take a name in one cell (last name,first name) .
 

I have a name in a cell, last name first then a comma then first name, and I
want to seperate them into two cells. I know there is a formula to do that,
but I don't know what it is, can anyone help me?

Use the menu option Data:Test To Columns to parse the one field into two fields


Good Luck

Stewart

"jobby" wrote:

I have a name in a cell, last name first then a comma then first name, and I
want to seperate them into two cells. I know there is a formula to do that,
but I don't know what it is, can anyone help me?

You could use Data Text to columns with comma as the
delimiter or use:

Last name (in B1):
=LEFT(A1,FIND(",",A1)-1)

First name:
=SUBSTITUTE(A1,B1&", ","")

HTH
Jason
Atlanta, GA



-----Original Message-----
I have a name in a cell, last name first then a comma
then first name, and I
want to seperate them into two cells. I know there is a
formula to do that,
but I don't know what it is, can anyone help me?
.