Hide too long text in a cell

R

Rene

How can I hide the part of the text that is too long for the cell? This
automaticly happens when in the cell on the right is already a text. But I
want this also when there is no text in the neighbouring cell. (Note: I don't
want to use wrap text)
 
K

Ken Wright

One way albeit a drudge, you can select the column next to it that has text in
only some cells, do Edit Go To / Special / Blanks, hit the spacebar to put a
single space in, and then use CTRL+ENTER to enter that in every blank cell.
 
Top