Search
Search titles only
By:
Search titles only
By:
Forums
New posts
Search forums
What's new
New posts
Latest activity
Feedback
View Statistics
Members
Current visitors
Buy Sell Trade
WTB
Log in
Register
Search
Search titles only
By:
Search titles only
By:
New posts
Search forums
Menu
Install the app
Install
Reply to thread
Forums
Technology
Computer Software
How to append "...etc" to a cell of fixed size in Excel?
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Message
<blockquote data-quote="chiron" data-source="post: 1713335" data-attributes="member: 2528"><p>I am preparing a tender schedule and the item descriptions are of different lenghts. Is there any way to format the cell so that it only displays the first say 50 characters and then adds a " ...etc" at the end. I don't want the actual cells contents to be truncated though.</p><p></p><p>I can do it by setting the formula in another cell as; [code]=IF(LEN(B127)<=30, B127, CONCATENATE(LEFT(B127,30-8)," …etc."))[/code] I want to know if it is possible to do so in cell formatting itself so that its dependent on the column width.</p><p></p><p>Any help in this regard would be appreciated <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite8" alt=":D" title="Big Grin :D" loading="lazy" data-shortname=":D" /></p></blockquote><p></p>
[QUOTE="chiron, post: 1713335, member: 2528"] I am preparing a tender schedule and the item descriptions are of different lenghts. Is there any way to format the cell so that it only displays the first say 50 characters and then adds a " ...etc" at the end. I don't want the actual cells contents to be truncated though. I can do it by setting the formula in another cell as; [code]=IF(LEN(B127)<=30, B127, CONCATENATE(LEFT(B127,30-8)," …etc."))[/code] I want to know if it is possible to do so in cell formatting itself so that its dependent on the column width. Any help in this regard would be appreciated :D [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
Technology
Computer Software
How to append "...etc" to a cell of fixed size in Excel?
Top
Bottom