Try this workbook, it uses formulae as requested.
In C2
=UPPER(LEFT(TRIM(B2),1)&" "
&LEFT(TRIM(MID(SUBSTITUTE(B2," ",REPT(" ",255)),1*255,255)),1)&" "
&LEFT(TRIM(MID(SUBSTITUTE(B2," ",REPT(" ",255)),2*255,255)),1)&" "
&LEFT(TRIM(MID(SUBSTITUTE(B2," ",REPT(" ",255)),3*255,255)),1)&" "
&LEFT(TRIM(MID(SUBSTITUTE(B2," ",REPT(" ",255)),4*255,255)),1)&" "
&LEFT(TRIM(MID(SUBSTITUTE(B2," ",REPT(" ",255)),5*255,255)),1))
In D2
=UPPER(LEFT(TRIM(B2),1)&A2&RIGHT(TRIM(B2),1))
This will return up to 6 initials, expand,contract the formula to suit your needs.
Bookmarks