Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Max number if characters in a merged cell
Maximum number of characters in my merged cell is 255. I thought that the
maximum number of characters in a cell is 1034. How can I fix this problem. thanks |
#2
|
|||
|
|||
The maximum number of characters in any cell is about 32k.
The maximum number of characters you can see in the cell is about 1024 unless you add alt-enters every 80-100 characters (to force new lines within the cell). But that 255 number seems suspicious. Does your merged cell have a formula that points to a closed workbook? If yes, then that's the way excel works. If you open the other workbook, you'll see all the characters. You may have to adjust the rowheight manually, though. Dajana wrote: Maximum number of characters in my merged cell is 255. I thought that the maximum number of characters in a cell is 1034. How can I fix this problem. thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fill or truncate to a certain number of characters in a cell | Excel Worksheet Functions | |||
How do you count number of characters in a single cell | Excel Worksheet Functions | |||
How do you count number of characters in a single cell | Excel Worksheet Functions | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
Defining a number in a cell by text then subtracting it by the tex | Excel Worksheet Functions |