If your problem is that the cell to the left isn't wide enough to display
its contents, then you have a number of options:
Widen the column, or
Reduce the font size, or
Format/ Cells/ Alignment, and select Wrap Text
--
David Biddulph

"GEORGE ZEIGLER, SAN DIEGO"
wrote in message
...
Thanks Max,

Here's my situation ... I have an alpha string of characters in a cell
directly to the left of the cell which tested for a formula and returned
the
value yielded by "". The string of alpha characters is about 20 characters
long, and I need to be able to see the string.

However the string is truncated when it hits the cell where the "" value
is
returned ... this makes me unable to see the string ... I'm thinking maybe
since there's a formula in the cell to the right, XL interprets the cell
as
"non-empty" and therefore causes the string in the cell to the left to be
truncated. I can't see anything in the "" cell, since it returns a null
set,
but it appears the formula itself is causing truncation.


"Max" wrote:

First thoughts .. pl remove the caps lock, it's difficult to read

If you mean return a null string ("") if D3 is blank
you could put it like this in say, E3: =IF(ISBLANK($D3),"",D3)

If you mean return a null string ("") if D3 is either blank or contains
zero
you could use in E3: =IF($D30,D3,"")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"GEORGE ZEIGLER, SAN DIEGO" wrote:
I have tried every method I can think of to return a blank cell as the
result
of a formula

EXAMPLES:
IF($D31,D3,"") HOPING "" COULD BE INTERPRETED AS EMPTY STRING
(BLANK
IF($D31,D3,A2) WHERE A2 IS A BLANK CELL

NO MATTER WHAT I TRY, XL AWAYS RETURNS 0'S ... THIS DOESN'T WORK FOR MY
APPLICATION. I CAN'T SEEM TO FIND A WAY TO HAVE A FORMULA RETURN A
BLANK
CELL.

ANY HELP IS GREATLY APPRECIATED !!!

THANKS ... GEORGE ZEIGLER, SAN DIEGO.