Formula to Swap Name From Last Name, First Name to First Name (space) Last Name

[squeakums]

I have a name setup in Column A and in the format Spy, Burt I want to setup a formual that will convert to Burt Spy in column B. I remember doing this in the past, but for some darn reason I cannot figure it out now. Any suggestions pretty please?

 

[VoG]

Take a look here http://www.cpearson.com/excel/FirstLast.htm

 

[VoG]

Or try

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

 

[Scott Huish]

=trim(mid(a1&" " & a1,find(",",a1)+1,len(a1)))