Excel 2007 - Stop long text from flowing to blank cell


I have some very long text in multiple cells.  I do not want to wrap the text.  I do not want the text to flow through into the adjacent blank cell(s).  How do I prevent the text from flowing outside of its cell?
ChrisIT ManagerAsked:
Who is Participating?
Mark the column with the text and set row height manually to standard height (12.75).
Then wrap text anyway. The text will wrap but not show more than one line.

One way might be to filll the adjacent cells with Nulls - eg: =REPT("",1)

(the Nulls would prevent the cell to the left encroaching)
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Good point, Zekalita!
ChrisIT ManagerAuthor Commented:
That's perfect!  Thanks!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.