title: Find the difference between two cells of text in Excel
body: <p>I have 2 cells that have lists of numbers in them separated by commas (,). The list in <code>K</code> is the full set, the list in <code>D</code> is the partial set. I would like to put into <code>M</code> the part of <code>K</code> that is not in <code>D</code>.</p>
  
  <p>example:</p>
  
  <p><code>K4 = 1,2,5,6</code></p>
  
  <p><code>D4 = 1,5,6</code></p>
  
  <p>Result <code>M4 = 2</code></p>
  
  <p>I have used <code>SUBSTITUTE</code>, but that only works when the numbers in <code>D</code> are in order and not missing anything from the middle of <code>K</code>.</p>
  
  <p>I need a non-VBA answer, please.</p>