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