Text Wrapping

[Davidns]

I have a cell with a rather lengthy text string which greatey exceeds the width of the cell. Upon double clicking the cell, the cell opens up to display the full text. When I click out of it, it reverts back to the partial view limited by the width of the cell. This is fine and works well for me.

The problem is if there is a line break in the text string. I can still double click on it to see the full string. However, when I then close the cell, text wrapping is turned on, which creates a mess for a cell with a lengthy text string.

Why does text wrapping get turned on when there is a line break? How can I prevent this from happening?

Thanks!
David

[DnDXan]

Hello Davidns,

you can try this these steps and see if they work for you

1) Press CTRL+H (i.e. shortcut for Find and Replace)

2) Click in the ‘Find what‘ field, hold down the ALT key and type 0010 (Use Number Key Pad, NOT Number Keys above Letter Keys).

It may not seem like anything happened but you actually entered an invisible line break character

3) Click in the ‘Replace with‘ field, press the spacebar once and click Find All. You will get a list of all cells containing a line break

4) At this point you can choose to Replace All.

It may not be apparent but you may have caused some cells to have two blank spaces. You can easily find and get rid of them by repeating the previous 4 steps, using two blank spaces in the ‘Find What‘ field and one blank space in the ‘Replace with‘ field.

Hope this helps!

DnDXan