Forum Discussion

Ocasio27's avatar
Ocasio27
Iron Contributor
Apr 06, 2020
Solved

Rearrangement and initials.

Hello, I am trying to modify a column that has a name order that is not the one I want as output.   Here is an example   How it looks Connor Smith, John   how I want it John Connor Smith   ...
excel
  • ExcelExciting's avatar
    ExcelExciting
    Apr 06, 2020

    HiOcasio27 

     

    You can do the same with the help of flashfill and below is the formula version can you use it to change the order of your names.

     

    Connor Smith, John > John Connor Smith

     

    =RIGHT(A2,LEN(A2)-FIND(",",A2)-1)&" "&LEFT(A2,FIND(",",A2)-1)

     

     

    To get the initials use the below formula 

     John Connor Smith > JCS

     

    =LEFT(B2,1)&MID(B2,FIND(" ",B2)+1,1)&MID(B2,FIND(" ",B2,FIND(" ",B2)+1)+1,1)

     

     

    Results 

     

    Attached is the sample file for your ready reference

     

    Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

    If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more

Abiola1's avatar
Abiola1
MVP
Apr 06, 2020
Hello,

All you need is Flash Fill

Assuming you have
Connor Smith, John in cell A1
Luiz Adrian, Rand in cell A2
Ibrahim Sule, Amad in cell A3 and so on

In cell B1, type in John Connor Smith and press Enter
In cell B2, press CTRL + E

You will have Rand Luiz Adrian in B2, Amad Ibrahim Sule in B3 and so on

If this answers your question, kindly accept as the Best Response.


Regards

Resources