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)) " ",)