Hi,

For a name in A1, try this formula in B1 (or C1, D1, ...)

=RIGHT(A1,LEN(A1)-FIND(" ",A1))&", "&LEFT(A1,FIND(" ",A1)-1)

The formula should work if there are no spaces within the firstname.

Regards,
B. R. Ramachandran


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