Limit cell width

[bklabel1]

I have a column that has about 150 characters. I only want the first 50 to be visible and the rest to be truncated. I don't care if there are ... to let me know if there are more characters. I right clicked to get to cell formatting. I can wrap text, shrink text to fit but I don't see a choice to truncate after a certain number of characters.

How can I do this?

Thanks,

Kevin

 

[Logit]

Home Tab, Cells, Format, Column Width.

 

[sandy666]

or

 

[bklabel1]

Home Tab, Cells, Format, Column Width.
It reduces the width of the column that has focus but the values inside still spill over to the one on the right column.

 

[shg]

You need to fill the cells in the next column with something to prevent spill. A space will do.

 

[Logit]

Or for those columns where the cell data "spills over", format them as "word wrap".

 

[bklabel1]

or
View attachment 18573

You need to fill the cells in the next column with something to prevent spill. A space will do.

This is just what I needed. Yes a space solved my issue. Appreciated.