I forget how to do this but I used to be able to in earlier versions of EXCEL.

Lets say I have a bunch of text which has the appearance of a paragraph.
Let's say each line starts in column B, so my text is in cols B10:B20. The
text strings are much longer than the width of col B, the the text extends
all the way to cols I, J and in some cases K. What I want is to make the
text not extend farther than column H. This would require some of the text
to move down to lower rows. Here is what I have been doing. I select cells
B10:H23 than then do

format/cells/alignment/horizontal/justify.

This doesn't do what I want. It moves all the text into the first column
(B), increases the heights of the rows significantly and the end result is
that nothing shows beyond column B. What I want is for the whole text blob
to be reformated so that all the text strings are still technically in col
B, but in display they extend rightward into adjacent cells but none goes
beyond col H. This involves haveing Excel treat the Text-strrings in Col B
as one big paragraph and reconfiguring them. I did this on older versions of
Excel. The commands were something like edit/fill/justify or
format/fill/justify or somethi8ng like that. I don't exactly remember. But
I can't figure out how to do what I want to do in EXCEL 2007. Can somebody
help me?


--
-regards