Spacing

I have columns W:AF that need to be formatted as such:

1) I need a space after each cell that actually contains text.
2) I do not want a space in cells that do not contain text.
3) I do not want a space after the last cell in a row that contains text.

For instace:

If I have: lets make code in cells W, X, and Y. I want cell AG (when I concatenate) to read lets make code with no space after code.
If I have lets code in cells W and X. I want cell AG (when I concatenate) to read lets code with no space after code

Seeing as how each row is different, is what I am asking possible?

Ben

Try

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

SLIGHT CORRECTION IS REQUIRED IN Dunc3142 Formula

=IF(W1>"",W1&" ","")&IF(X1>"",X1&" ","")&IF(Y1>"",Y1&" ","")&IF(Z1>"",Z1&" ","")&IF(AA1>"",AA1&" ","")&IF(AB1>"",AB1&" ","")&IF(AC1>"",AC1&" ","")&IF(AD1>"",AD1&" ","")&IF(AE1>"",AE1&" ","")&IF(AF1>"",AF1&" ","")

as

=TRIM(IF(W1>"",W1&" ","")&IF(X1>"",X1&" ","")&IF(Y1>"",Y1&" ","")&IF(Z1>"",Z1&" ","")&IF(AA1>"",AA1&" ","")&IF(AB1>"",AB1&" ","")&IF(AC1>"",AC1&" ","")&IF(AD1>"",AD1&" ","")&IF(AE1>"",AE1&" ","")&IF(AF1>"",AF1&" ",""))