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.