cell contents (text) run into neighbours

[Katie S.]

Hi,
I'm having a hard time finding out how to stop the text
contents of one cell (say A1 containing the text "the
quick brown fox jumps over the lazy dog") from running
into its neighbours (A2:A4). Unlike with numerical entries
(which are shortened if the cell's too small), text
entries (formatted as Text or General) run on & on until
they either run out of text or hit a filled cell. I don't
want to wrap the text at all - I just want the visible
text to be limited to the width of the cell (e.g.: "the
quick"), without having to add in extra, dummy columns of
space-bar 'contents' next to each column of long text. Any
ideas about how to limit what is seen?
Thanks.

 

[Malcolm Graham]

What would happen if you just put a space character in the
column to the right of your text column -- would that
cause format problems by causing this column to be
designated as 'text' ?

 

[Earl Kiosterud]

K-K-K-Katie (showing my age),

You may be able to accomplish this with Wrap, and setting the row heights to
what they already are (select the rows, change the height, then back to what
it was). This turns off Autofit (Format - Row - Autofit), and the wrapped
stuff just won't show.