View Single Post
  #12   Report Post  
Old February 21st 21, 08:02 PM posted to microsoft.public.excel.worksheet.functions
Auric__ Auric__ is offline
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2003
Posts: 538
Default formula to switch last/first name around?

Moeka Nakagawa wrote:

On Wednesday, August 28, 2019 at 9:51:39 AM UTC-4,
wrote:
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


What if you want John Doe to become Doe John with no commas and only
space in between?


Remove the comma from Claus' formula:

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

--
Help will always be given to those who ask for it.