ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Text formatting (https://www.excelbanter.com/excel-discussion-misc-queries/127195-text-formatting.html)

richmond

Text formatting
 
Despite formatting and re-formatting (wrap text, cut and paste into Word and
then re-pasted as HTML) and having a fraction of the ~32K capacity for a
cell, I can't get all of the text to show up in a cell. How can I fix this
problem? Thanks.

Dave Peterson

Text formatting
 
I'm not sure you'll ever see 32k characters in the cell.

But if you add alt-enters to force a new line within the cell every 80-100
characters, you'll see way more than the 1000 or so that's documented in Excel's
help.

richmond wrote:

Despite formatting and re-formatting (wrap text, cut and paste into Word and
then re-pasted as HTML) and having a fraction of the ~32K capacity for a
cell, I can't get all of the text to show up in a cell. How can I fix this
problem? Thanks.


--

Dave Peterson


All times are GMT +1. The time now is 04:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com