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!!!

[T. Valko]

Here's another one:

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

--
Biff
Microsoft Excel MVP

"Stilla" <Sti...@discussions.microsoft.com> wrote in message
news:C190DF76-9F93-44EF...@microsoft.com...

[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

"B. R.Ramachandran" <BRRamac...@discussions.microsoft.com> wrote in
message news:40599D8B-249D-4DCA...@microsoft.com...

[bla...@slcsd.org]

What about if I want to change it from John Brown to Brown, John??

[Claus Busch]

Hi,

Am Tue, 20 Oct 2015 13:02:32 -0700 (PDT) schrieb bla...@slcsd.org:

> What about if I want to change it from John Brown to Brown, John??

try:
=MID(A1&", "&A1,FIND(" ",A1)+1,LEN(A1)+1)


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

[primary...@gmail.com]

I'm 10 years late to this thread, but your formula works a treat! thanks

[Moeka Nakagawa]

What if you want John Doe to become Doe John with no commas and only space in between?

[Auric__]

Remove the comma from Claus' formula:

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

--
Help will always be given to those who ask for it.