formula to switch last/first name around?
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?