| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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! |
|
#2
|
|||
|
|||
|
=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! . |
|
#3
|
|||
|
|||
|
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! . |
|
#4
|
|||
|
|||
|
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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| concatenate a text string if two different cells contain the sam. | Excel Worksheet Functions | |||
| Help adding text values | Excel Worksheet Functions | |||
| Concatenate cells without specifying/writing cell address individually | Excel Discussion (Misc queries) | |||
| Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Hybrid Mode
