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
|