title: Select empty cells in R
body: <p>How do I select empty cells from column D1 of my database (image attached)</p>
  <p>I tried as follows:</p>
  <pre><code>df&lt;-read_excel('C:/Users/Antonio/Desktop/test.xlsx')
  x&lt;-subset(df,df$D1==&quot;&quot;)
  </code></pre>
  <p>But it did not work.</p>
  <p><a href="https://i.stack.imgur.com/5SCc6.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/5SCc6.png" alt="enter image description here" /></a></p>