Avoiding excel cropping text when next cell contains formula

Udi - Dec 12, 2014 at 03:37 AM

If you have empty cells to the right, text from a cell will float over the columns following. However, if you have a formula placing "empty text" ("") in the cells this will crop the text from a preceding cell.

How can this be avoided. I have very narrow columns and want to place a long (30 char) text in only one of the cells in a row.

I'm using Excel 2011 for Mac.