# of Characters in a cell

B

Bill Graves

I have a wookbook with a cell that I want to put 1300 or characters into.
According to the specification a cell should allow 32000 characters. However
the cell is cutting off the last 100 or characters. Any thoughts on why?
 
D

Dave Peterson

The number of characters you can type in a cell and the number of characters you
can see don't have to be the same!

But you can see lots more than the 1000 (or so documented in Excel's help) by
adding alt-enters (to force a new line within the cell) every 80-100 characters.
 
A

Alan

Although you can have 32,000, only 1024 can be displayed on the screen. They
show up in the formula bar, but not in the cell.
You can force it to show a lot more by hitting Alt-Enter every 600
characters or so to start a new line, something I only recently found out
myself,
Regards,
Alan.
 

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

Splitting cell contents into other columns 1
check first 3 characters of a cell and compare to a table 4
Cell limit of characters 4
Cell Formats - Limit # of characters 3
Total Cell Characters Count 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Extracting all info in Cell except last 3 characters 2
Formula to validate characters within a string of data in aparticular cell 1

Top