Function to Rearrange Name

[Karen]

Let's say I have a cell (A1) that contains the following:
Smith, John D.
and I want a formula that will return:
John D. Smith

How can this be done?
Thank you

 

[N Harkawat]

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

 

[Karen]

Thank you VERY much - It works great!

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

 

[Gary Brown]

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