Thanks p45cal, that is the solution. There is indeed a formula in each of the cells being concatenated, e.g. =IF(O20<>0,O20&" hrs " &TEXT(B20,"d-mm-yy"),""), so they look empty when there's no data to display.

So thank you very much indeed for the solution!