Add Space between concatenate cells

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!

=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!
>.
>

Mac Landers wrote...
>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,"")
Try

=T(F2)&" "&T(G2)&" "&T(H2)&" "&T(I2)&" "&T(J2)

Thank you!

"Jason Morin" wrote:

> =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!
> >.
> >
>