I have the following formula which returns a blank text string rather than, specifically, nothing.

=IF(ISBLANK(DD28),"",DD28)

This affects the text in the surrounding cells which don't overlap if there is an empty text string in the cell(s) next to it.

So basically, it has to return an empty cell rather than a cell which just looks empty.

I can't expand the cells as the table is being used directly into a web page.

Any help would be greatly appreciated.

Even if it's just getting the cell's text to be 'shown on top' or something similar.