hi
i have formula were i need some changes
=UPPER(LEFT(TRIM(RIGHT(SUBSTITUTE(TRIM(N3)," ",REPT(" ",99)),(1+(LEN(N3)-LEN(SUBSTITUTE(N3," ",""))>2)+(LEN(N3)-LEN(SUBSTITUTE(N3," ",""))>4))*99))&","&N3,LEN(N3)))
INPUT IS -Jacqueline M.R. Belanger
OUT PUT IS - BELANGER,JACQUELINE M.R.
i...