=TRIM(TEXT(F2,"")&" "&TEXT(G2,"")&" "&TEXT(H2,"")&" "&TEXT
(I2,"")&" "&TEXT(J2,""))

HTH
Jason
Atlanta, GA

-----Original Message-----
I am trying to combine five cells together. All of the
cells do not always
have text, they are linked to another spreadsheet so
when the cell is blank
in Sheet 1, the linked cell in Sheet 2 returns zero. I
used the following
formula so the zeros would not show up in the
concatentate formula only
words; however, now I need spaces between the words.

=TEXT(F2,"") &TEXT(G2,"")&TEXT(H2,"")&TEXT(I2,"")&TEXT
(J2,"")

I would appreciate any help.
Thanks!
.