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!

Its because if you type text into a cell it will spill over into empty cells
so it can be read. If you then enter in another location a formula to
capture what is in the target cell as you describe then that cell will have
to be widened to show all the text contained therein. The cell containing
the formula will not spill over as the original.
Regards,
Alan.
"Sam" wrote in message
...
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!

if you format the cell to allow text wrapping it will automatically make the
cell larger so you can see it all

"Alan" wrote:

Its because if you type text into a cell it will spill over into empty cells
so it can be read. If you then enter in another location a formula to
capture what is in the target cell as you describe then that cell will have
to be widened to show all the text contained therein. The cell containing
the formula will not spill over as the original.
Regards,
Alan.
"Sam" wrote in message
...
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!

I have duplicated what you do under Excel 2000, and presume that when
you say "lots of text" you are referring to only that amount of text
that is visible across the screen, say about 150 characters per cell.
Note, a cell can hold up to 32,768 characters, but only 1024 are
displayed except in the formula bar, and a height limit of 409 points
applies to each row, limiting the usefulness of the 'wrap' in this
case.

On Sheet2 I applied your formula and could see all of the text (to the
maximum of my screen width) that was visible in Sheet1.

I could, by highlighting all relavant cells (including the overflow
display cells), copy these as a Picture (Enhanced Metafile) to give the
required results, from either Sheet1 or Sheet2 into a Word (2000)
document.

Which version of Excel are you using? Have you checked the contents of
the following column?
If so, on Sheet1, try Edit, Move or Copy Sheet, tick to create a copy,
and insert your formula into this sheet to test.

If this works for you it can then replace your current Sheet2, or
analize your current Sheet2.


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=389490