Change a name field from LAST FIRST ordered to FIRST LAST ordered.

Question

I have an excel spreadsheet with about 700 entries. The names are listed as "DOE JOHN" (no comma separating the names). I need to format them so they read JOHN DOE.

1.) I would like to learn how to do this in excel.

2.) I would like to learn how to do this in linux.

Thanks!

Answer 1

If your LAST FIRST data in A1:A10, for example, paste this worksheet formula into B1. Then copy and paste into B2:B10.

=MID(A1,FIND(" ",A1)+1,LEN(A1))&" "&LEFT(A1,FIND(" ",A1))

If you then want to get rid of the LAST FIRST data, select B1:B10 and choose Edit - Copy. Select A1:A10, select Edit - Paste Special - Values.

Be sure to review B1:B10 before you paste values over your original data to make sure it worked like you expect.