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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - In Excel- change the order of a name? Bill Gates to Gates, Bill (https://www.excelbanter.com/excel-discussion-misc-queries/47797-excel-change-order-name-bill-gates-gates-bill.html)

arnold36

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

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)))

--
Regards,
Dave

"arnold36" wrote:

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

All times are GMT +1. The time now is 12:23 AM.