Perhaps my original question was unclear.
In cell A1 the name as currently written is Microsoft Excel. I need to have
the name as Excel, Microsoft.
I have tried the suggested formulas but keep getting the #VALUE! error.

"B. R.Ramachandran" wrote:

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?