Format changes in a merged cell

[P_Kellogg]

I have 9 columns and 10 rows merged in order to type text. Because I have
many lines of text (25 rows at least) I have expanded the last row in order
to see all the text. The merged cell is formated for centering but once I
get past row 25 it becomes right justified. I have deleted the cells and
started over but it always changes formatting at about 25 lines of text.

Regards, Paul

 

[Shane Devenshire]

Hi,

the answer is version dependent:

2003:
Cells can contain 1024 characters in a formula
Cells can contain 32,767 text characters but only the first 1023 will be
visible (unless you use Alt Enter to force line breaks)

this is probably the problem you are experiencing above - the first 1023
characters wiil be visible, although while you type you see more, but with
alignment not the same. In 2003 your solution is to use Alt Enter as stated
above.

2007:
Cells can contain 8192 characters in formulas
Cells can contain 32,767 text characters in cells and all can be seen and
printed without needing to use Alt Enter.

 

[P_Kellogg]

Thank you, Shane. This helps.
I am using 2003 and ALT Enter. I must be reaching the 32,767 character limit.

As a follow-up, do you know how excel counts characters? By using ALT Enter
and placing 1 character per line, could you have 32,767 lines or does Excel
count the potential spaces on the line as characters? Thank you again for
the support.

Paul