I am using the substitute function to remove blank spaces in strings of text in cells AD187 and AD191, as follows:
In cell AD187
=SUBSTITUTE(C188," ","")&IF(I188="","x",I188)&IF(K188="","x",K188)&SUBSTITUTE(C189," ","")&IF(I189="","x",I189)&IF(K189="","x",K189)&SUBSTITUTE(C190,"...