Automaticaly stop at the margin and wrap-text as if it's a full screen cell?

[mikeyates]

I'm auto-referencing a survey into a report.
Some of the answers are really long, but they're just one cell.
I can't wrap text, because it's just one cell.
I can't adjust that column, because I have other content in that column.

Right now, I'm inserting a row under the ugly row, merging all of the cells, and formatting them to wrap, and then pasting the formula necessary to input the data needed.

It'll work, but I was wondering if there was a way to automate this.

Here's what the ugly report looks like.

 

[Micron]

And the good report would look like what?
Don't understand why you say you can't wrap because it's one cell. If you're merging cells in columns to make things fit, then it can't be because a cell with wrapped text makes for a taller row unless maybe you want a tall merged cell and nothing in the rest of the row below. So describing what you want doesn't really work for me.

If this ends up being about a way to wrap text on new lines by inserting linefeed/carriage returns then I can only envision a complicated code solution. You'd also have to use a fixed width font because "wow" and I'll are both 3 characters but the words are not the same width in most fonts.

 

[mikeyates]

And the good report would look like what?
Don't understand why you say you can't wrap because it's one cell. If you're merging cells in columns to make things fit, then it can't be because a cell with wrapped text makes for a taller row unless maybe you want a tall merged cell and nothing in the rest of the row below. So describing what you want doesn't really work for me.

If this ends up being about a way to wrap text on new lines by inserting linefeed/carriage returns then I can only envision a complicated code solution. You'd also have to use a fixed width font because "wow" and I'll are both 3 characters but the words are not the same width in most fonts.

I'm trying not to merge cells, because it's very time consuming. I have to insert a row, then merge and format to wrap.

Here's what it looks like after I do everything one line at a time. This may very well not be feasible. I was just curious. I have high expectations of this forum and don't know what I don't know.

 

[Micron]

Can you not just make column A as wide as the sum of the other 5 (?) column widths that you're not using and set text to wrap in column A? Based on what you show I cannot see any reason why you can't just set the wrap text property on column A.

 

[mikeyates]

Can you not just make column A as wide as the sum of the other 5 (?) column widths that you're not using and set text to wrap in column A? Based on what you show I cannot see any reason why you can't just set the wrap text property on column A.

No, because like I previously mentioned, I have other information that will be distorted. This is just one part of the report. There are several parts to it.

 

[Micron]

If you're looking for design suggestions consider posting a wb copy on a file share somewhere. Otherwise I don't know what to suggest.

I can't wrap text, because it's just one cell.

That's the part I guess I don't understand the why not. Wrapped cell make the whole row higher but that's not usually an issue. Cells with shorter lines don't wrap, like below. Top row left column is not merged. Next row same column is wrapped as is column 2 row 1. Last 4 rows column 1 are not wrapped.

I probably should bow out because I'm not helping.