Link to home
Start Free TrialLog in
Avatar of Chris
ChrisFlag for United States of America

asked on

Excel 2007 - Stop long text from flowing to blank cell

Hello,

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?
Avatar of DonkeyOte
DonkeyOte

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

(the Nulls would prevent the cell to the left encroaching)
ASKER CERTIFIED SOLUTION
Avatar of Zekalita
Zekalita

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Good point, Zekalita!
Avatar of Chris

ASKER

That's perfect!  Thanks!