![]() ![]() ![]() ![]() I'd really prefer not to use VBA/macros if possible, as I'm a relative novice at them. I'd like it to adjust automatically if I narrow or widen the column width as well. Ultimately, I'd like the row height to adjust automatically to the content I'm trying to display. Its behavior seems inconsistent, though I'm sure it must be something I've done or am doing wrong. The problem is that row height will not always adjust for me automatically. Some of these cells have enough content to fit on one line at the given width while others require multiple lines to fit the content. The reality is I have multiple cells like A4, with varying content lengths (all under the limit able to be displayed in a cell). There is no carriage return - the split occurs because the cell is formatted to wrap text and the cell width only fits 20 characters. I would expect cell A4 to show 4 lines of text:Ī1 content in line 1 of cell A4 followed by a carriage returnĪ2 content in line 2 of cell A4 followed by a carriage returnĪ3 content in lines 3 and 4 of cell A4 the first 20 characters of A3 content should appear in line 3 and the last 20 characters should appear in line 4. All cells in column A have been formatted to wrap text. The width of column A fits 20 characters. Let's use this as an example:Ī4 has the formula =a1&CHAR(10)&a2&char(10)&a3 I have a formula in a cell that returns text from multiple cells and inserts a carriage return in between the contents from each cell. I have looked and looked for an answer that helps me, but not found it worded quite the way I need it. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |