1. Forum
  2. Usenet
  3. MSOFT.PUB.EXCEL.WORKSHEET

  • formula to switch last/first name around?

    From primaryenergise@gmail.com@21:1/5 to Stilla on Wed Aug 28 06:51:36 2019
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Moeka Nakagawa@21:1/5 to primary...@gmail.com on Tue Jan 26 11:52:54 2021
    On Wednesday, August 28, 2019 at 9:51:39 AM UTC-4, primary...@gmail.com 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?

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Auric__@21:1/5 to Moeka Nakagawa on Sun Feb 21 20:02:21 2021
    Moeka Nakagawa wrote:

    On Wednesday, August 28, 2019 at 9:51:39 AM UTC-4, primary...@gmail.com 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.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)