ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Long text gets cut off in the cell (https://www.excelbanter.com/setting-up-configuration-excel/83586-long-text-gets-cut-off-cell.html)

coco44

Long text gets cut off in the cell
 
I am using Excel 2003 and I need to enter a long text into a cell. But
although the entire text gets displayed in the formular bar, it's cut off in
the cell no matter how I format the column. Please help.

Thanks!


Dave Peterson

Long text gets cut off in the cell
 
Excel's help says that it'll display 1024 characters (all 32767 will appear in
the formula bar).

If you add alt-enters (to force new lines within the cell) every 80-100
characters, you'll see far more than the 1024 limit that excel's help gives.

coco44 wrote:

I am using Excel 2003 and I need to enter a long text into a cell. But
although the entire text gets displayed in the formular bar, it's cut off in
the cell no matter how I format the column. Please help.

Thanks!


--

Dave Peterson


All times are GMT +1. The time now is 06:02 AM.

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