Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When I copy down into the next cell the formula changes correctly. | Excel Discussion (Misc queries) | |||
How is it that a cell can transfer the correct formula, but the w. | Excel Discussion (Misc queries) | |||
Formula with text and reference to a date cell | Excel Discussion (Misc queries) | |||
Cell contents vs. Formula contents | Excel Discussion (Misc queries) | |||
I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) |