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.