Swap first and last name

[briansimmons2112]

In my spreadsheet, I have a column of names written as last name then a space then a first name and sometimes another space then middle initial. Is there a way to put the last names on the other side of the first name and middle initial so it reads as first name, space, middle initial, space, last name?

[robleyd]

One way of doing it - with the name in A1, put this formula in B1;

Code: Select all

=TRIM(MID(A1;SEARCH(" ";A1)+1;LEN(A1)))&" "&LEFT(A1;SEARCH(" ";A1)-1)

The attached file contains some extra columns that may help you understand the whole formula if necessary.

name_reverse.ods

(20.68 KiB) Downloaded 95 times