length of character data

  • Thread starter Thread starter Saravanan
  • Start date Start date
S

Saravanan

If I keep typing all characters in a cell, how many
characters can a cell contain ?
In other words , a line in a cell can contain how many
characters ?

Thanks.

==
 
Hi
1024 characters is the maximum for a cell to display. If you want to extend
this limit you may enter manual linebreaks with ALT+ENTER
 
32,767 is the number of characters that can be entered in a cell.

However......only 1024 of these will display.

The maximum width of a column is 255 characters, so word wrap must be enabled
to see the full 1024.

See Frank's post for a partial work-around using ALT + ENTER.

Gord Dibben Excel MVP
 
You must log in or register to reply here.

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

Indent based on character length 4
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
grouping with vba 1
Excel Help creating Excel formula 1
Word wrap with > 255 characters 2
Formula to validate characters within a string of data in aparticular cell 1
Error message is Character Limit is over 1024 characters 2
CSV->Excel Data Problem 1

Back
Top