Flip Values in Single Column

[Guest]

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?

 

[Rob]

Assuming Peter Rowlans is in cell A1, the following formula will show
Rowlands Peter. Depending on your needs, either insert a column alongside
the existing one and copy the formula down 8000 rows and leave as that or
copy down but then copy and paste value over the original. This formula
only works if the names are in the format you stated.

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

HTH Rob

 

[Guest]

Try this

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