255 characters in a cell

G

Guest

Is there a way to view more than 255 characters in a cell? You can see all
the characters in the edit bar at the top, but in the field, you can't see
anything voer 255. Is there a way around this limitation??

Using Excel 2000 or 2003
 
J

JE McGimpsey

XL00 and XL03 both allow 1024 characters to be displayed in a cell. Try
expanding your cell height or width. To view more, you'll have to insert
line breaks (OPT-ENTER) at least every 1024 characters.
 
G

Guest

What about XL02. I have the same limitation in XL02. Alt-Enter helps but
not that much.
 
D

Dave Peterson

I've seen at least 15,000 characters by using lots of alt-enters and a small
enough font.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Word wrap with > 255 characters 2
How do I get more than 255 characters into a cell? 3
Why can't I get more than 255 characters in one cell in Excel 07? 1
How can I copy more than 255 characters in a cell without truncati 1
How do I copy more than 255 characters per cell? 2
Why is Excel truncating my text to 255 characters? 2
Merge a cell based on count of characters 4

Top