In Excel- change the order of a name? Bill Gates to Gates, Bill

What is the formula for changing the order of a name?

Assume your name is in cell A1:

=CONCATENATE(RIGHT(A1,LEN(A1)-SEARCH(" ",A1)),", ",LEFT(A1,SEARCH(" ",A1)))

--
Regards,
Dave


"arnold36" wrote:

> What is the formula for changing the order of a name?