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



"Karen" wrote:

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