This only works if the data you want to keep is in the leftmost two and rightmost five positions in the string. It will turn "White Space" into "WHSPACE" which isn't exactly what Elisa was asking for.=UPPER(CONCATENATE((TRIM(LEFT(A1,2))),(RIGHT(A1,5))))
eg. ND 10552 = ND10552
Hiya,
how about:
=Substitute(A2," ","")
Adam