<div>
You cannot. Formula means that there is something in the cell and it cannot be the same as a clearcontent.
</div>


You cannot. Formula means that there is something in the cell and it cannot be the same as a clearcontent.

<div>
I just want to be able to use the End DownArrow functionality to get to the next populated cell.
</div>


I just want to be able to use the End DownArrow functionality to get to the next populated cell.

<div>
A cell with a formula is populated.<br />
<br />
Have you copied the formula down to far, past the data?<br />
<br />
Is there an adjacent column you could find the end of and then move across?
</div>


A cell with a formula is populated.

Have you copied the formula down to far, past the data?

Is there an adjacent column you could find the end of and then move across?

<div>
I've copied the formula down a column, not past the data. &nbsp;I'm just using the fact that the cell has a value in it to indicate something to me and I would like to go to each subsequent instance of a cell without data. &nbsp;I know I could use a filter to show only the cells with the text in them, but I want to be able to see the rows inbetween.
</div>


I've copied the formula down a column, not past the data.  I'm just using the fact that the cell has a value in it to indicate something to me and I would like to go to each subsequent instance of a cell without data.  I know I could use a filter to show only the cells with the text in them, but I want to be able to see the rows inbetween.

<div>
What you are trying to do cannot be done without the help of VBA
</div>


What you are trying to do cannot be done without the help of VBA

<div>
<div class="content wysiwyg-content">
My formula is:<br />

<pre><code id="code-10-28141938-1">=if(A1=&quot;Joe&quot;,&quot;It's him!&quot;,&quot;&quot;)</code></pre>
<br />
If A1 is not Joe, I want the cell to contain nothing at all, null, as if I did a clear contents on it.<br />
<br />
How can I do that WITHOUT using VBA? &nbsp;I just want to do it in the formula.
</div>
</div>


My formula is:
(CODE)

If A1 is not Joe, I want the cell to contain nothing at all, null, as if I did a clear contents on it.

How can I do that WITHOUT using VBA?  I just want to do it in the formula.

in Excel, how can I assign NULL to a cell without using VBA?

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.