Formula to change Name format

[Kiley]

I have the name:

Smith,Jane A

and I would like a formula that changes it to:

Jane A Smith

 

[Luke M]

Try:

=MID(A2,FIND(",",A2)+1,256)&" "&LEFT(A2,FIND(",",A2)-1)

 

[Kiley]

Thank you so much!

Try:

=MID(A2,FIND(",",A2)+1,256)&" "&LEFT(A2,FIND(",",A2)-1)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*