First Name Last Name to Last Name First Name

[rizmomin]

Hello:

I have name as First Name Middle Initial Last Name (Example John E Doe)
How would i convert it as Last Name, First Name Middle Initial ( Result as Doe, John E)

Please help and let me know if any questions.

Thank you

Riz Momin

[martindwilson]

=TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",20)),20))&", "&TRIM(LEFT(SUBSTITUTE(A1," ",REPT(" ",20)),40)) would do it

[rizmomin]

Hi Martinwilson:

Thanks a lot, it works.

Riz Momin

[Andrew1983PL]

Hello,

=right(B30;DŁ(B30)-find("*";substitute(B30;" ";"*";len(B30)-len(substitute(B30;" ";"")));1))&", "&substitute(B30;right(B30;DŁ(B30)-find("*";substitute(B30;" ";"*";len(B30)-len(substitute(B30;" ";"")));1));"")

Regards

[AndyLitch]

This works for John E Doe and John Doe

=(IF((IF((LEN(A1)-LEN(SUBSTITUTE(A1," ","")))>1,FIND(" ",A1,(FIND(" ",A1,1))+1),""))<>"",RIGHT(A1,LEN(A1)-(IF((LEN(A1)-LEN(SUBSTITUTE(A1," ","")))>1,FIND(" ",A1,(FIND(" ",A1,1))+1),""))),RIGHT(A1,LEN(A1)-(FIND(" ",A1,1))))) & ", " & (IF((LEN(A1)-LEN(SUBSTITUTE(A1," ","")))>1,MID(A1,(FIND(" ",A1,1))+1,(IF((LEN(A1)-LEN(SUBSTITUTE(A1," ","")))>1,FIND(" ",A1,(FIND(" ",A1,1))+1),""))-(FIND(" ",A1,1))),"")) & " " & (LEFT(A1,(FIND(" ",A1,1))-1))