Stop text from stringing into next field when empty

[NothingButRomance]

Thank you for that info, but I guess I should have mentioned that on
too. I tried that and it makes the rows way too tall, so that is not a
option either. I also can't "shrink to fit" because then my Mom won't b
able to see the words. I just thought there was a way to "contain" th
text in a cell and have it "cut off" where the next cell begins.

Thanks!

 

[Peo Sjoblom]

If you put something in the next cell it will not fill over, you could put
="" for instance

 

[Max]

If you put something in the next cell it will not fill over,

you could put ="" for instance

Hitting a space would be slightly faster, no? <g>

But the OP did mention this ..

hit the space button to make the field
before it (with the sentence) think that its not empty,

But thought that this part of the original post
may not be quite correct, going by tests carried out here ..

but that only works while you have it open, even if you save,
the string comes back the next time you access the file.

The space(s) remained where they were hit or copied down

 

[Dave Peterson]

Spaces may be slightly faster, but for me, they're extremely difficult to
noctice.

But if I put ="" in a cell, I can select the cell and see it in the formula
bar. Entering a space character adds some time when I want to find out what's
in that cell. (Pay me now, or pay me later???)

 

[Mangesh Yadav]

Wrap text, and re-fix the row height to whatever standard size you want.

- Mangesh

 

[Max]

It was meant in the spirit of light banter, Dave !
But I see your point (and Peo's)

(Pay me now, or pay me later???)

No or's about that, I wanna be paid now and later <g>

 

[Dave Peterson]

I didn't mean to get too serious, but I bet most people who inherit workbooks
from others who clear cells with the spacebar, hate that.

(I do!)

 

[Max]

I didn't mean to get too serious,
but I bet most people who inherit workbooks
from others who clear cells with the spacebar, hate that.
(I do!)

Granted, Dave. Thanks. And I guess that's why I tend towards a liberal use
of TRIM in formulas pointing to textual data. One never knows when a (extra)
spacebar hit is intentional or accidental.