If the First, Last is in a single cell, you need to break it up first. Here
are the steps:

1) Find the location of the comma with the Find function. If the text is
in A1, B1 could be =FIND(",",A1)

2) Then use this value to get the first name. C1 would be =LEFT(A1, B1-1_

3) Use the position of the comma to get the last name. D1 would be
=MID(A1, B1+1, 99999)

4) Now combine the last and first name. E1 would be =CONCATENATE(D1,
",",C1)

Of course you could combine all these steps in a single cell, that that gets
tricky.

Once you are done, you can Copy, Paste Special (Values), to save your
results and delete the columns used to make the conversion.

Hope this helps.
"VDan" wrote in message
...
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?