• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to keep text from getting truncated by neighboring cell

dronka

dronka

Member
I have a block of cells that each have the same equation in them that inserts into the cell a symbol or text based on a formula. I then conditionally format the block based on the symbol within each cell. The columns are very narrow in the block, and longer text gets truncated by the cell next to it.

I'd like to find a way to get the truncated text to show up even when there is an equation in the neighboring cell. See uploaded sample. The "longer text" gets truncated by the cell next to it. Is there any way around this?
 

Attachments

  • Sample.xlsx
    9.2 KB · Views: 3
Good day dronka

It cannot be much easier than placing your cursor between B and C in the column headers and double clicking or select a block of headers, ABCDEFG and placing the cursor between one letter and double clicking
 
Good day Marc L

Formatting wrap will do it but it does make a mess of the row the long text is in, all cells in the row will have the same height as the largest warped cell, I know the column widths will all be the same as the widest column in the double click method it just that they do not look so untidy.
 
I'd like the column width to remain the same (in other words, no double clicking to increase column width). And I agree that wrapping text looks messy (and won't work for my application, which has longer text than is in the sample). See this uploaded file for what I'd like to see happen. I did this by deleting the equations in the cells to the right of the longer text. I want the text to be able to show up like this while maintaining the equations in every cell. In other words, when the equation inserts a blank, I'd like Excel to treat it as a blank cell and allow the text to extend across it.
 

Attachments

  • Sample_v2.xlsx
    9.1 KB · Views: 3
Hi, dronka!
I'm bad news: summary, if you don't want to wrap cells or widen columns, you can't.
Regards!
 
I kind of thought that might be the answer, but I was hoping that some of you Excel Gurus would have a genius way to beat Excel at its own game. Thank you all for posting to this thread!
 
Hi, dronka!
Sorry for not being able to help you, but here there're only gurus (among other specimens) and not any magicians. Thanks for your feedback and for your kind words too. And welcome back whenever needed or wanted.
Regards!
 
You must log in or register to reply here.
Back
Top