Results 1 to 3 of 3

Thread: Splitting name with various combinations using excel formulas

  1. #1

    Splitting name with various combinations using excel formulas



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,


    I have a name in cell a1 (arun kumar gupta). I need out put in cell b1 as (arun k gupta,arun gupta,gupta arun,arun kumar,arun kumar g,g arun kumar,a k gupta).


    Kindly show me with formula how to split "arun kumar gupta" with various name combinations as i mentioned above into single cell followed by comma(,).


    Can anyone help me.....


    I looking forward your response.
    Last edited by RAJERAM1; 2015-08-06 at 04:26 PM.

  2. #2
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    Hi,
    Try in cell B1

    =LEFT(A1,FIND(" ",A1,1)-1)&" "&MID(A1,FIND(" ",A1,1)+1,1)&" "&TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",99)),198,99))&","&LEFT(A1,FIND(" ",A1,1)-1)&" "&TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",99)),198,99))&","&TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",99)),198,99))&" "&LEFT(A1,FIND(" ",A1,1)-1)&","&LEFT(A1,FIND(" ",A1,1)-1)&" "&TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",99)),99,99)&","&LEFT(A1,FIND(" ",A1,1)-1)&" "&TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",99)),99,99))&" "&TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",99)),198,11))&","&TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",99)),198,11))&" "&LEFT(A1,FIND(" ",A1,1)-1)&" "&TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",99)),99,99))&","&LEFT(A1,1)&" "&MID(A1,FIND(" ",A1,1)+1,1)&" "&TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",99)),198,99)))

  3. #3
    This is what I expect.

    Amazing.....Thank you so much.

    regards,
    Ramesh R

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •