Excel

K

Kelly

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?
 
P

Paul B

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
 
Top