how to show only partial field contents

T

tuqqer

Using Excel 2004.

How do you set a template so that, if you place more text in a field
than can be show, it only shows the first word, and doesn't
distort/change the field length, or wrap the text.

Man, that's a tough thing to describe. Hope it makes sense. I have
small fields in my doc, and sometimes entire paragraphs that need to go
into the fields. I don't want text wrapping, nor 5-feet long fields. I
only want it to show the words that fit, until you click on it, or
hover your mouse over it.


phew. That gave me a headache just describing it...
 
J

JE McGimpsey

tuqqer said:
Using Excel 2004.

How do you set a template so that, if you place more text in a field
than can be show, it only shows the first word, and doesn't
distort/change the field length, or wrap the text.

Man, that's a tough thing to describe. Hope it makes sense. I have
small fields in my doc, and sometimes entire paragraphs that need to go
into the fields. I don't want text wrapping, nor 5-feet long fields. I
only want it to show the words that fit, until you click on it, or
hover your mouse over it.
Click to expand...

If you put a space character (or anything else) in the cell to the right
of your input cell, and don't set the input cell to wrap, you'll only
see the amount of text (i.e., characters rather than words) that fit in
the cell.

To display only the first word, you'd need to use VBA.
 
Top