Is there a space between the the first and last name in your data?
For example: Bill Gates (in cell C7) should return Gates, Bill.
"VDan" wrote:
I did.
"David Hepner" wrote:
You need to change all of the C7's in the formula to the cell that has the
name.
"VDan" wrote:
excel responded #VALUE!
"David Hepner" wrote:
Try this:
=MID(C7,FIND(" ",C7,1)+1,LEN(C7)-FIND(" ",C7,1)) & ", " & LEFT(C7,FIND("
",C7,1))
"VDan" wrote:
Both names are in the same cell.
"Mike" wrote:
in the next column do
=concatenate(Lastnamecell,", ",Firstnamecell)
"VDan" wrote:
Hi,
I have a list of names in excel that is currently listed Firstname Lastname.
I need it to be listed Lastname, Firstname.
Is there a way to do this?
|