formula to switch last/first name around?

[Stilla]

Is there a formula I can copy into say, cell B1, that will change a name in
cell A1 from "Brown, John" to John Brown?

Thanks to all you excel wizards out there!

 

[Sean Timmons]

Assuming you ONLY have ast name comma space first name:

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

 

[Stilla]

Sheer GENIUS!!!!! WOnderful!!!

Assuming you ONLY have ast name comma space first name:

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

 

[T. Valko]

Here's another one:

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

 

[Sean Timmons]

Thank you much! I've had to use it myself many times...

 

[B. R.Ramachandran]

Hi Biff,

Very elegant formula!

B. R. Ramachandran

 

[T. Valko]

Thanks!

--
Biff
Microsoft Excel MVP

Hi Biff,

Very elegant formula!

B. R. Ramachandran