Hi
sorry, missed that point. See Harlan's response (as this is not possible)

--
Regards
Frank Kabel
Frankfurt, Germany

Using formulas to enter NULL cell values wrote:
Thanks for the reply, however, this does not appear to work ... if A2
is not null, the TRUE argument value is placed in the cell, but this
does NOT allow the value of A2 (if longer than the cell width) to
'bleed' into B2 as desired. Even though the TRUE value is
(essentially) NULL, it apparently is NOT the same as the result you
would get if you right-clicked on the cell and used Clear Contents
... I want to effect a "Clear Contents" result from within a formula

"Frank Kabel" wrote:

Hi
=IF(A2<"","",B1)

--
Regards
Frank Kabel
Frankfurt, Germany

Using formulas to enter NULL cell values wrote:
I am trying to effect a null cell value based on a formula. For
example, for B2, I might want to have B2 be NULL if A2 is NOT NULL,
otherwise use the value from B1). This might be written something
like "=if(A2"",NULL,B1)".

The intent is to allow the text value of A2 to extend into B2 (i.e.
not wrap). Entering a "" for the TRUE action does not allow A2 to
extend into B2.