Hi
Assuming your data is in column A and the names are separated by a space
then in column B enter
=MID(A2,FIND(" ",A2)+1,99)&" "&LEFT(A2,FIND(" ",A2)-1)
Copy down as far as required.
Then, copy column B and Paste Special>Values to fix the data.
If your data is separated by a comma, then insert a comma between the double
quotes in both instances
in the above formula ","