Reformatting Names in Excel

[Cal10]

I am trying to reform names in Excel by using a formula. Everything I find only include Fist last name. I need to reformat a name with multiple commas

Currently reading:Doe, Jon, MD
Need to read Jon Doe MD

How can I do this without using Text to columns and only using a formula.

Thanks!

 

[Cal10]

The layout is now correct however I still have a comma after the surname and the last two characters.

Reading as: David Gooding, MD
I need David Gooding MD

 

[Rick Rothstein]

The layout is now correct however I still have a comma after the surname and the last two characters.

Reading as: David Gooding, MD
I need David Gooding MD

Ah, no comma before the last two characters. That means the formula I posted in Message #8 needs to change to this instead...

=MID(LEFT(A1,LEN(A1)-4)&" "&LEFT(A1,LEN(A1)-4),FIND(",",A1)+2,LEN(A1)-5)&" "&RIGHT(A1,2)

 

[Cal10]

I got it! Thank you everyone for your help, it is greatly appreciated

 

[Rick Rothstein]

Ah, no comma before the last two characters. That means the formula I posted in Message #8 needs to change to this instead...

=MID(LEFT(A1,LEN(A1)-4)&" "&LEFT(A1,LEN(A1)-4),FIND(",",A1)+2,LEN(A1)-5)&" "&RIGHT(A1,2)

Actually, the above formula can be simplified a little bit...

=MID(LEFT(A1,LEN(A1)-4)&" "&A1,FIND(",",A1)+2,LEN(A1)-5)&" "&RIGHT(A1,2)

 

[AlKey]

It is always the same format. Last, First, AA

Now you contradict your own statement

 

[Cal10]

My apologies if I did but how did I contradict myself? The format is consistent on the sheet as the original layout is last, first, AA. I needed it to read first last aa with no commas. Sorry if I was not clear