I am using an IF formula to return a text string if conditions are satisfied and return a blank cell "" if conditions are not satisfied.
My problem is that the when the text is returned from the formula, half of it is cut off by the adjacent cell because excel does not recognise "" as an empty cell.
Does anyone know how I can force the text to overlap into the next cell.
My spreadsheet is set up like a calendar, so I cannot alter column widths or hide columns.
Can anyone help?
My problem is that the when the text is returned from the formula, half of it is cut off by the adjacent cell because excel does not recognise "" as an empty cell.
Does anyone know how I can force the text to overlap into the next cell.
My spreadsheet is set up like a calendar, so I cannot alter column widths or hide columns.
Can anyone help?
