R
robotman
I've had a couple people ask me about the maximum number of characters
they can put in a cell because Excel was cutting off their entries.
While researching the question, I found you can enter up to 32K
characters into the formula, but only the first 1024 will display on
the sheet.
(Note: You can add some <Alt><Enter>'s to extend this a bit, but the
text starts getting cut-off.)
I came up with a work-around that I didn't see anywhere that I wanted
to post in case someone in the future runs across this problem and
wants to go beyond the 1024 limit.
To get around the 1024 display limit, you can create a Text Box to fit
pefectly in the cell in question. The text box will display more than
1024 characters. You may have to reduce the font size and increase the
cell size, but the text box will size with the cell and look like part
of the spreadsheet. The only difference is that you enter text
directly into the Text Box rather than the formula bar.
To create a Text Box that fits perfectly into a cell, hold down the
<ALT> key while creating the text box and the Text Box edges will snap
to the cell borders.
You may also want to make the line color to "none" so the text box
blends seamlessly with the surrounding cells.
Hope this helps someone some day....
John
they can put in a cell because Excel was cutting off their entries.
While researching the question, I found you can enter up to 32K
characters into the formula, but only the first 1024 will display on
the sheet.
(Note: You can add some <Alt><Enter>'s to extend this a bit, but the
text starts getting cut-off.)
I came up with a work-around that I didn't see anywhere that I wanted
to post in case someone in the future runs across this problem and
wants to go beyond the 1024 limit.
To get around the 1024 display limit, you can create a Text Box to fit
pefectly in the cell in question. The text box will display more than
1024 characters. You may have to reduce the font size and increase the
cell size, but the text box will size with the cell and look like part
of the spreadsheet. The only difference is that you enter text
directly into the Text Box rather than the formula bar.
To create a Text Box that fits perfectly into a cell, hold down the
<ALT> key while creating the text box and the Text Box edges will snap
to the cell borders.
You may also want to make the line color to "none" so the text box
blends seamlessly with the surrounding cells.
Hope this helps someone some day....
John