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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
modifying name format within a cell 2
Reversing first and last names in one cell 5
splitting Last Name, First Name 4
How to split cell based on capitalised suburb name 3
Seperate last name from a cell with full name 3
Windows 10 I would like to know in a batch file how to indentify computer name by using the first 5 of the name and the last 2 of the name then call runcmd 0
Break up a name 3

Back
Top