MERGING TEXT TO "SQUARE IT UP"

[bobshef]

I have a grid on my Worksheet in cells A1 through Cell J20. Under the grid I need to type a paragraph. I want the text "squared up" on the right side as well as the left. I typed the entire paragraph in cell B25 because when you merge, only the upper left cell contents are captured. I grabbed a large area of cells and did a FORMAT CELLS, ALIGNMENT, HORIZONTAL=JUSTIFY, VERTICAL=TOP, and MERGE is checked.
Sometimes it works great. Other times, with very large amounts of text, only about 10 rows of text appear when I leave the formatted text area. If I go back into the newly merged area, the text is still there. It is just cutting off after the first 10 or so sentences. Is there a limit on how many text characters I can use when merging?

 

[Hasit]

Two things. Make sure WORD WRAP is also checked. And if only 10 sentences worth are appearing, then you have not merged enough lines (by the sounds of things). Merge a cfew more lines to see if all your text appears.

I tested it on 97 and 2000 and I was able to merge 80 lines (and more) and was able to show all the text justified or otherwise....

 

[bobshef]

I've re-tried this on 3 different computers. 2 home computers and 1 office NT system. It simply does not work. Thanks for the input anyway.

 

[Hasit]

I may have misunderstood what you are trying to do then, as I have been able to merge upto 80 lines without problems, and get the text to justify.

If you want, you can send me the file and I'll take a look at it:

hasitbakhda@yahoo.co.uk

 

[Hasit]

Bobshef, I got the file thanks! And I see the problem. I tried it on 2000 and it worked fine, and although I tested it on 97 nI was not using a huge amount of text (I repeated the same word, so it was difficult for me to see the problem).

I concede it is a problem, and heres the proof:

http://support.microsoft.com/default.aspx?scid=kb;EN-GB;q176472&GSSNB=1

However, I did work around your problem in two ways:

1. I reduced the font size and it fitted perfectly. This method however does not require as many rows of cells to be merged.

2. I increased the number of columns merged, maintaining the font size and again, it fitted fine.

Looks like you are gonna have to upgrade to 2000 to address this problem.

I have replied to your email as well BTW.