formula to switch last/first name around?

  • Thread starter Thread starter Stilla
  • Start date Start date
S

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!
 
Assuming you ONLY have ast name comma space first name:

=RIGHT(A1,LEN(A1)-FIND(",",A1)-1)&" "&LEFT(A1,FIND(",",A1)-1)
 
Sheer GENIUS!!!!! WOnderful!!!

Sean Timmons said:
Assuming you ONLY have ast name comma space first name:

=RIGHT(A1,LEN(A1)-FIND(",",A1)-1)&" "&LEFT(A1,FIND(",",A1)-1)
Click to expand...
 
Back
Top