View Single Post
  #6   Report Post  
Old October 1st 09, 12:39 AM posted to microsoft.public.excel.worksheet.functions
B. R.Ramachandran B. R.Ramachandran is offline
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2007
Posts: 61
Default 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!