Try this

=RIGHT(A1,LEN(A1)-FIND(" ",A1))&" "&LEFT(A1,FIND(" ",A1)-1)



"Syed" wrote:

I have first name and last name in a single column it goes firstname,
lastname. the file has 8000 names is there any way i can flip it to
lastname, firstname?