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