formula to switch last/first name around?

6939 views
Skip to first unread message

Stilla

unread,
Sep 30, 2009, 1:17:01 PM9/30/09
to
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

unread,
Sep 30, 2009, 1:25:01 PM9/30/09
to
Assuming you ONLY have ast name comma space first name:

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

Stilla

unread,
Sep 30, 2009, 1:44:01 PM9/30/09
to
Sheer GENIUS!!!!! WOnderful!!!

T. Valko

unread,
Sep 30, 2009, 1:49:37 PM9/30/09
to
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

unread,
Sep 30, 2009, 3:25:01 PM9/30/09
to
Thank you much! I've had to use it myself many times...

B. R.Ramachandran

unread,
Sep 30, 2009, 7:39:01 PM9/30/09
to
Hi Biff,

Very elegant formula!

B. R. Ramachandran

T. Valko

unread,
Sep 30, 2009, 9:24:33 PM9/30/09
to
Thanks!

--
Biff
Microsoft Excel MVP


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

bla...@slcsd.org

unread,
Oct 20, 2015, 4:02:37 PM10/20/15
to
What about if I want to change it from John Brown to Brown, John??

Claus Busch

unread,
Oct 21, 2015, 1:07:18 AM10/21/15
to
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

unread,
Aug 28, 2019, 9:51:39 AM8/28/19
to
I'm 10 years late to this thread, but your formula works a treat! thanks

Moeka Nakagawa

unread,
Jan 26, 2021, 2:52:57 PM1/26/21
to
What if you want John Doe to become Doe John with no commas and only space in between?

Auric__

unread,
Feb 21, 2021, 3:02:24 PM2/21/21
to
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.
Reply all
Reply to author
Forward
0 new messages