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?