| 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 |
| 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 | |||
Threaded Mode
