Hello, I see the problem
try this
Zero Space Empty
Form 0
length 1 1 0
Formula
0 '=WENN( D2="" ; D2 ; "" )
length 0 0 1
in englisch versions use if instead of WENN
You see - empty cells have a length of zerro, where space is like a
character from the length 1
If you will ask for a empty cell you have two alternatives in IF-statements
a) if(length(A1)=0;A;B) or
b) if(A1="";A,B)
I use the german version OOO 3.1
Franz
Tamblyne schrieb:
I'm trying to copy certain cells from one sheet to another. If the
first cell is empty, I want the second cell to be empty, too, or,
ideally, just have a space in it. Right now, I get "0". I tried an
"IF" statement, but I can't seem to make it happy. Now I'm getting
Err:511 or #NAME?.
This is for a template where the first sheet may have 2 or more rows.
I don't want to have to go into the second sheet and delete all the
extra rows that won't have anything in them every time I use the
template.
Also, if there are hyperlinks in the cell in the first sheet, only the
link text appears in the cell in the second sheet -- not the hyperlink
that's supposed to go with it. Is there anything that can be done
about that?
Thanks
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
