I'm trying to stop long text from overflowing in to the next cell over, I know this question has been posed here before, but that was many years ago, and I'm hoping they fixed this in 2007. If you took a standard cell (say A1), with nothing to the right, and pasted this post into it, it would overflow and cover all cells to the right. There are two fixes I've commonly seen suggested to stop this, and neither will work.

1. Place a space in the cell to the right, the cell is no longer empty and the text to the left will end on that cell. The problem with this is it also breaks functions like counting blank cells or counting non blank cells, it won't work for me.
2. Wrap text, I really don't want to wrap text, I hate the way it looks. This method doesn't break functions, I just can't stand to have 200 characters wrapped inside a 5 character text box, it doesn't work for me.

Besides, neither are really "fixes", they are ways to work around a problem that, I believe, MS should have put an option in for long ago. The original problem remains. So is there a fix in Excel 2007?