Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Add Space between concatenate cells
0 views
Skip to first unread message
Mac Landers
Feb 1, 2005, 2:57:06 PM2/1/05
to
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.
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!
Jason Morin
Feb 1, 2005, 3:07:42 PM2/1/05
to
=TRIM(TEXT(F2,"")&" "&TEXT(G2,"")&" "&TEXT(H2,"")&" "&TEXT
(I2,"")&" "&TEXT(J2,""))
(I2,"")&" "&TEXT(J2,""))
HTH
Jason
Atlanta, GA
>.
>
Harlan Grove
Feb 1, 2005, 3:14:13 PM2/1/05
to
Mac Landers wrote...Try
=T(F2)&" "&T(G2)&" "&T(H2)&" "&T(I2)&" "&T(J2)
Mac Landers
Feb 1, 2005, 3:27:01 PM2/1/05
to
Thank you!
0 new messages