Long Text Strings Not Showing In Adjacent Cells

[texdavek]

Under macro control, I copy a list of text strings from one worksheet to
another. The text strings are long. In the target cells, text is
showing only in the target cell. I'd like to have it flow into adjacent
cells as well since nothing is there. The format cells options don't
seem to have an effect.

How do I get the entire text strings to show without visiting each cell
in the worksheet?

Thanks.

 

[BrianB]

Clear the contents of the adjacent cells (?)

Regards
BrianB
================================================