Number of characters in a cell (one row, merged columns)

G

Guest

I have a cell with one row and four merged columns. I have a macro for
autofit and the information from other sheet copies into that cell
automatically. However I tought that the maximum number of characters is
1024 however it seems that my cell can take more than 1024 characters. What
is the maximum number of characters this cell can take. Also when I run a
macro not all information is visible, my cell indeed expands but it does not
expand all the way so I have to do it manually. Does anyone know a solution
to this problem.

Thanks
Dajana
 
G

Guest

This is in the help file:-

Length of cell contents (text) 32,767 characters. Only 1,024 display in a
cell; all 32,767 display in the formula bar.

Even with this limitation, it is possible to see more than the 1024 by
adding alt-enters (to force new lines in the cell) every 80-100 characters
 

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

Max number if characters in a merged cell 1
Auto Row Height with Wrapped Text in Merged Cells Problem 3
Is it possible to enter more than 255 characters in a cell 2
Getting word wrap to work in a merged cell 1
Cell names of merged cells 1
Excel 2003 - Maximum number of characters a cell can contain? 1
sorting two columns of merged cells 1
Wrap Text doesn't work in Merged Cell 1

Top