Use a helper column with the below formula to reverse the names..Once done
copypaste specialvalues and remove the current column

=TRIM(MID(A1,FIND(" ",A1)+1,255)) & " " & LEFT(A1,FIND(" ",A1)-1)

You will require some find tuning to handle single names...

If this post helps click Yes
---------------
Jacob Skaria


"kathy at the front desk" wrote:

I have a name list that is first name then last name in same cell. Is there a
way to make it last name then first name? Same cell would be great. Thanks