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?

 [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.