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