Sometimes can see all text in a cell, sometimes not.

S

Sam

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!
 
A

Alan

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.
 
T

tired of finding my data scrambled

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

Bryan Hessey

I have duplicated what you do under Excel 2000, and presume that whe
you say "lots of text" you are referring to only that amount of tex
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 ar
displayed except in the formula bar, and a height limit of 409 point
applies to each row, limiting the usefulness of the 'wrap' in thi
case.

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

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

Which version of Excel are you using? Have you checked the contents o
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, o
analize your current Sheet2
 
Top