ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   formula to switch last/first name around? (https://www.excelbanter.com/excel-worksheet-functions/244176-formula-switch-last-first-name-around.html)

Stilla September 30th 09 06:17 PM

formula to switch last/first name around?
 
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 September 30th 09 06:25 PM

formula to switch last/first name around?
 
Assuming you ONLY have ast name comma space first name:

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

"Stilla" wrote:

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!


Stilla September 30th 09 06:44 PM

formula to switch last/first name around?
 
Sheer GENIUS!!!!! WOnderful!!!

"Sean Timmons" wrote:

Assuming you ONLY have ast name comma space first name:

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

"Stilla" wrote:

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!


T. Valko September 30th 09 06:49 PM

formula to switch last/first name around?
 
Here's another one:

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

--
Biff
Microsoft Excel MVP


"Stilla" wrote in message
...
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 September 30th 09 08:25 PM

formula to switch last/first name around?
 
Thank you much! I've had to use it myself many times...

"Stilla" wrote:

Sheer GENIUS!!!!! WOnderful!!!

"Sean Timmons" wrote:

Assuming you ONLY have ast name comma space first name:

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

"Stilla" wrote:

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!


B. R.Ramachandran October 1st 09 12:39 AM

formula to switch last/first name around?
 
Hi Biff,

Very elegant formula!

B. R. Ramachandran

"T. Valko" wrote:

Here's another one:

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

--
Biff
Microsoft Excel MVP


"Stilla" wrote in message
...
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!





T. Valko October 1st 09 02:24 AM

formula to switch last/first name around?
 
Thanks!

--
Biff
Microsoft Excel MVP


"B. R.Ramachandran" wrote in
message ...
Hi Biff,

Very elegant formula!

B. R. Ramachandran

"T. Valko" wrote:

Here's another one:

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

--
Biff
Microsoft Excel MVP


"Stilla" wrote in message
...
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!







[email protected] October 20th 15 09:02 PM

formula to switch last/first name around?
 
On Wednesday, September 30, 2009 at 12:17:01 PM UTC-5, Stilla wrote:
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!


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

Claus Busch October 21st 15 06:07 AM

formula to switch last/first name around?
 
Hi,

Am Tue, 20 Oct 2015 13:02:32 -0700 (PDT) schrieb :

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

[email protected] August 28th 19 02:51 PM

formula to switch last/first name around?
 
On Wednesday, 30 September 2009 18:17:01 UTC+1, Stilla wrote:
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!


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


All times are GMT +1. The time now is 06:44 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
ExcelBanter.com