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