The formula below changes the order of a name from Last Name, First Name Middle to First Name Middle LastName. In order for this to work, every cell entry can only contain one comma, for example: Mann, Max R.

Be sure to copy the formula correctly, changing cell references as appropriate

=RIGHT(A1,LEN(A1)-LEN(LEFT(A1,FIND(”,”,A1)-1))-2)&” “&LEFT(A1,FIND(”,”,A1)-1)

NOTE: Do not delete column A. Doing so will result in a #REF error in column B, as the formula in B references Column A. If you must delete Column A, first copy the data in column B and use Edit, Paste Special, Values to copy the data to an empty column. Once the values are pasted, you can delete both Columns A and B.