Replace value with Blank not null()

If [something]=1 then "it is one"

Else [Do Nothing]

end if

I want my cell value should be blank.(Adding new column formula tool).i am not able to achieve [Do Nothing] this part.

This is possible by "find replace " ,but I don,t think that's the solution.

Regards,

Subhajit

Capturezzzz.PNG

Preparation

Accepted answers

markcurry

If you don't want to add nulls, you can and an empty string "" instead....

IF [something] = 1 THEN
"it is one"
ELSE
""
ENDIF

You can check for Empty strings with that IsEmpty function. Hope that helps

Bennel_Wilson

Hi @subhajits11 ,

I agree with the approach of @markcurry . A simple formula tool with the formula should do the trick.

The result this step would leave all other cells with blank spaces, what I mean is they're necessarily not empty and in an excel output they wont show as blanks. See below:

Screenshot (440).png

So as a final act, you could use a data cleaning tool to remove all such white spaces which should leave the result column with absolute blank cells. See below:

Attached workflow for your reference.

Regards

Benn

P.S: In case this solves your query, kindly mark as solution.

Blank cells.yxmd

All comments