View Single Post
  #10   Report Post  
Old August 28th 19, 02:51 PM posted to microsoft.public.excel.worksheet.functions
[email protected] is offline
external usenet poster
First recorded activity by ExcelBanter: Aug 2019
Posts: 1
Default formula to switch last/first name around?

On Wednesday, 30 September 2009 18:17:01 UTC+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!

I'm 10 years late to this thread, but your formula works a treat! thanks