Limit cell width

bklabel1

Board Regular
Joined
Feb 24, 2015
Messages
130
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
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

sandy666

Banned - Rules violations
Joined
Oct 24, 2015
Messages
7,497
or
colw.png
 

shg

MrExcel MVP
Joined
May 7, 2008
Messages
21,825
Office Version
  1. 2010
Platform
  1. Windows

ADVERTISEMENT

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

Logit

Well-known Member
Joined
Aug 31, 2016
Messages
4,301
Or for those columns where the cell data "spills over", format them as "word wrap".
 

Forum statistics

Threads
1,148,189
Messages
5,745,243
Members
423,937
Latest member
The Great Dane

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top