View Single Post
  #5   Report Post  
Old September 30th 09, 08:25 PM posted to microsoft.public.excel.worksheet.functions
Sean Timmons Sean Timmons is offline
external usenet poster
First recorded activity by ExcelBanter: Aug 2006
Posts: 1,696
Default 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!