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

J

jobby

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

Datasort

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


Good Luck

Stewart
 
J

Jason Morin

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
 
Top