Thanks for your reply. My problem is that I can not waterfall the effect as
I need column B to run almost into most of column A. What I really think I
need is a macro that would look at the contents of cells in column A and
then insert a complete row ABOVE any cell that contains text and move that
text to the new created row. Then I would be able to waterfall the rest B,
C, etc


"JLGWhiz" wrote in message
...
You can waterfall the entries, so long as they are on different rows.
Ther restriction is that text in one column (any column) will truncate at
the right edge of the column if there is any type of datat in the column
to the right, including a space which you cannot see. Also as I
previoulsy pointed out, You can use just column A and expand it as wide as
you need and use spaces to make the waterfall effect. What have you
tried?


"Stanley Braverman" wrote in message
...
The rows are different widths. I need full row width on column A and
adjustable widths on column B but column B must be able to fit under
column A??

Allman Brothers Band, The (column A)

Candy Everybody Wants DK082-04 (Column B)
4Non Blonds (column A)

What's Up DK086-07 (column B)


"Canlink" wrote in message
...
On Feb 7, 7:47 pm, "Stanley Braverman" wrote:
I am puzzled. Is it possible to have a row that contains say about 20 or
so
characters.
And then the row below it starts about 5 characters after the beginning
of
the row and then have both rows show up in a printing? :example
<-----coulomb A----------
Time For All good men..etc
Yes It Can be-------------4546-03(column B)
<-------------column B-----------

You are really talking about two rows one starting in Column "A" and
the other in Column "B". Column "A" should match 5 characters in
width (size depends on your Font) and Column "B" can be wide enough to
support all the remaining characters after the first five. You do not
need to but you can merge column "A" and "B" in the first row.