Is there anyway to make a cell blank using a formula. For example if there is text in the cell clear it? I've tried if(istext(A2),"",A2) but the "" is not really an empty cell, it is text (ISTEXT() returns true and ISBLANK() returns false).
I can do this with a macro (I think it is with .ClearContents(), I but want to do it in a formula.
Thanks,
Curt
I can do this with a macro (I think it is with .ClearContents(), I but want to do it in a formula.
Thanks,
Curt