Trying to change names in a guest list all in the same column. Example: John Doe--->Doe, John.
This is the formula: =MID(A1,FIND(" ",A1,1)+1,LEN(A1)) & ", " & LEFT(A1,FIND(" ",A1))

Like I said the formula result lists exactly what I want but then the Circular Reference warning pops up and then prevents the desired result from occurring...any ideas??