ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Excel (https://www.excelbanter.com/excel-worksheet-functions/121232-excel.html)

Kelly

Excel
 
I am using one of the columns on my spreadsheet for comments after about
1,000 characters the words no longer wrap in the cell. How can I fix this?

Paul B

Excel
 
Kelly, A cell can have 32,767 characters, but only the first 1,024
characters will display in a cell; you can see all 32,767 display in the
formula bar.
If you add a few alt-enters (to force a new line within the cell) every
80-100
characters, you'll be able to see lots more than the documented 1024
characters


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Kelly" wrote in message
...
I am using one of the columns on my spreadsheet for comments after about
1,000 characters the words no longer wrap in the cell. How can I fix this?





All times are GMT +1. The time now is 12:46 PM.

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