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

[arnold36]

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

 

[David Billigmeier]

Assume your name is in cell A1:

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