fill a cell with blank spaces using excel formula

**Lakshminarasimhan** · 05-12-2013, 03:07 AM

Dear All,

I need to clear a value in a cell(what ever may be the value) based on a condition in another cell and set it to blank.
Ex: If cell A is blank and then i need make cell B also blank, if cell A has some value then i should not disturb B
I need to do this using formula.
I have tried the below, but no use,
IF(AA1="",REPLACE(Y1,1,10,""))

Any ideas gurus?

**dilipandey** · 05-12-2013, 03:22 AM

Hi Lakshmi,

welcome to the forum.
Is there any formula in cell B?

If not and cell B has some value, then the only solution here is macro (vba).. check and confirm. thanks.

Regards,
DILIPandey
<click on below * if this helps>