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)))
Bookmarks