add substitute formula to this formula
=SUBSTITUTE(UPPER(LEFT(TRIM(RIGHT(SUBSTITUTE(TRIM(C3)," ",REPT(" ",99)),(1+(LEN(N68)-LEN(SUBSTITUTE(C3," ",""))>2)+(LEN(C3)-LEN(SUBSTITUTE(C3," ",""))>4))*99))&","&C3,LEN(C3)))," ","")
this formula will delete the space bar
Bookmarks