Try

=TRIM(TEXT(W1," ?;;; @")&TEXT(X1," ?;;; @")&TEXT(Y1," ?;;; @")&TEXT(Z1," ?;;; @")&TEXT(AA1," ?;;; @")&TEXT(AB1," ?;;; @")&TEXT(AC1," ?;;; @")&TEXT(AD1," ?;;; @")&TEXT(AE1," ?;;; @")&TEXT(AF1," ?;;; @"))