Stopping fields bleeding into other fields

[Dan Morris]

Hello

I would be most grateful if someone could help me with this as I can't find any option or way of doing this within Excel or by searching the forums:

Where you have long text strings in a field, if there is nothing in the next field(s) then that text bleeds across the empty fields until there is a field with something in it. This makes it difficult to visually see blank fields. I can't see any option to stop this from happening.

Is there a way of doing this?

Thank you. Dan

 

[Michael M]

I'd suggest either making ALL columns a little wider OR use word wrap.

 

[Dan Morris]

Thanks Michael;these are very long text strings so wrap won't work for me nor will widening the fields to the full length; do you know of any other way other than putting spaces in the adjacent fields? Best wishes.

 

[Michael M]

The only other thing I can think of is
At the end of a sentence, or some sensible point in the text string press ALT + Enter
this will force the text to a new line in the cell