Home > other >  Insert string(" ") into named-range merged-cell but only if empty
Insert string(" ") into named-range merged-cell but only if empty

Time:09-26

So I have a cell where I'll be putting strings, but sometimes that cell will be empty, when it is I'd like to insert a " " to indicate that the cell needs a string.

How would I go about this?

I tried referencing itself but that was dumb after thinking about it.

=IF(ARRAYFORMULA(ISBLANK(MergedCells1)) " ",)

enter image description here

  • Related