View Single Post
  #4   Report Post  
Old September 30th 09, 06:49 PM posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
First recorded activity by ExcelBanter: Nov 2006
Posts: 15,768
Default formula to switch last/first name around?

Here's another one:

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

Microsoft Excel MVP

"Stilla" wrote in message
Is there a formula I can copy into say, cell B1, that will change a name
cell A1 from "Brown, John" to John Brown?

Thanks to all you excel wizards out there!