How do I display more than 1,024 characters in Excel 2003?

A

ask4excelhelp

Excel is limited to 1,024 characters showing within a cell, while the
additional characters (up to 37K+) display in the formula bar. Does anyone
know a way around this without adding an extra cell?
 
D

Dave Peterson

If you add alt-enters every 80-100 characters, you'll see more than 1000 (or so)
characters.
 
M

Marcelo

if you are trying to copy a huge text in one cell, press f2 before ctrl v

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"ask4excelhelp" escreveu:
 

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

Problem printing a large excel cell 5
Number of characters in a cell 2
Test For 1,024 Characters 5
How do I get more than 255 characters into a cell? 3
Need Workaround for Cell Display Limitation in Excel 2000 5
Why can't I get more than 255 characters in one cell in Excel 07? 1
Excel 2003 - Maximum number of characters a cell can contain? 1
need way to handle large csv imports that overflow cell size 3

Top