| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenate and empty cell
I am trying to use concatenate to put together 3 cells only if another cell
has data in it. If E9 is blank then the formula would leave a blank cell otherwise it will concatenate the data that is in H9,I9,J9,K9. I have tried differing formulas using IF and cannot get it to work. Fish |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Concatenate and empty cell
hi
this works... =IF(E9="","",H9&I9&J9&K9) if you want spaces.... =IF(E9="","",H9&" "&I9&" "&J9&" "&K9) regards FSt1 "Fish" wrote: I am trying to use concatenate to put together 3 cells only if another cell has data in it. If E9 is blank then the formula would leave a blank cell otherwise it will concatenate the data that is in H9,I9,J9,K9. I have tried differing formulas using IF and cannot get it to work. Fish |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Concatenate and empty cell
Thank you very much, I had tried many different ways using IF and Concatenate
and could get it to leave the cell blank but never put the data together. Thanks again, Fish "FSt1" wrote: hi this works... =IF(E9="","",H9&I9&J9&K9) if you want spaces.... =IF(E9="","",H9&" "&I9&" "&J9&" "&K9) regards FSt1 "Fish" wrote: I am trying to use concatenate to put together 3 cells only if another cell has data in it. If E9 is blank then the formula would leave a blank cell otherwise it will concatenate the data that is in H9,I9,J9,K9. I have tried differing formulas using IF and cannot get it to work. Fish |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Concatenate and empty cell
Your example puts four cellls together, not three. Anyhow:
=IF(E9="","",H9 & I9 & J9 & K9) -- Gary''s Student - gsnu200765 "Fish" wrote: I am trying to use concatenate to put together 3 cells only if another cell has data in it. If E9 is blank then the formula would leave a blank cell otherwise it will concatenate the data that is in H9,I9,J9,K9. I have tried differing formulas using IF and cannot get it to work. Fish |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Concatenate and empty cell
=+IF(E90,H9&J9&K9&L9,"")
This should concatenate cells H9,J9,K9, and L9 only if E9 has a value greater than zero. You would have to change this is E9 could have negative numbers. Thanks, Chuck "Fish" wrote: I am trying to use concatenate to put together 3 cells only if another cell has data in it. If E9 is blank then the formula would leave a blank cell otherwise it will concatenate the data that is in H9,I9,J9,K9. I have tried differing formulas using IF and cannot get it to work. Fish |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When is a cell empty and how do I empty it. | Excel Discussion (Misc queries) | |||
| format a cell with a formula so an empty reference cell shows blan | Excel Discussion (Misc queries) | |||
| Leaving an empty cell empty | Excel Discussion (Misc queries) | |||
| why a reference to an empty cell is not considered empty | Excel Discussion (Misc queries) | |||
| How to concatenate a url and the value of another cell | New Users to Excel | |||
Hybrid Mode
