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.