Hello

On Sheet1, I can see all text in cells that have lots of text in them, but
have cells to the right that are empty.

On Sheet 2, I pasted the following formula into cell A1, and copied this
into all
of the cells on Sheet2:
=IF(Sheet1!A1=0,"",Sheet1!A1)

Now I can't see all of the text in a cell, even if the cell to the right of
it is empty.

Is there anything that can be done? I am copying these cells and pasting
them into Word as a picture.

Thanks!