View Single Post
  #8   Report Post  
Old October 20th 15, 09:02 PM posted to microsoft.public.excel.worksheet.functions
[email protected] is offline
external usenet poster
First recorded activity by ExcelBanter: Oct 2015
Posts: 1
Default 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??