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!

 

[AliGW]

How many different formats are there? Or is it always surname, first_name, AA? Do you want the result in one column or three?

 

[Cal10]

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

 

[Cal10]

I did not see the 2nd part of your question. I need the results in one cell

 

[AliGW]

This should do it (where the text is in A1):

=MID(A1,FIND(",",A1)+2,3)&" "&LEFT(A1,FIND(",",A1)-1)&SUBSTITUTE(RIGHT(A1,FIND(",",A1,FIND(",",A1)-1)),",","")

 

[Cal10]

When I plug in this formula it is only grabbing the first 3 letters of the first name then adding the remaining letters of the first name to the end of the last name.

Ex: Gooding, David, MD is showing as Dav Goodingvid MD.

 

[Cal10]

I have approx 1200+ names and each name varies in length

 

[Rick Rothstein]

Assuming the text after the last comma is always two characters long (as your previous posts suggest), give this formula a try...

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

 

[AlKey]

in B2

=TRIM(MID(SUBSTITUTE(A1,",",REPT(" ",50)),50,50))&" "&LEFT(A1,FIND(",",A1)-1)&" "&TRIM(RIGHT(SUBSTITUTE(A1,",",REPT(" ",50)),50))

Unknown
	A	B
1	Doe, Jon, MD	Jon Doe MD
Sheet1

 

[vicedo]

Try this too

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

OR

=MID(A1,FIND(" ",A1)+1,FIND(",",A1)-1)&" "&LEFT(A1,FIND(",",A1)-1)&" "&TRIM(CLEAN(RIGHT(SUBSTITUTE(A1,CHAR(160),CHAR(32)),2)))