title: =IF(ISNUMBER(SEARCH.... the difference between 1 and 11
body: <p>I am trying to convert a single column of numbers in excel to multiple depending on the content. </p>
  
  <p>e.g. Table 1 contains 1 column that contains 1 or more numbers between 1 and 11 separated with a comma. Table 2 should contain 11 columns with a 1 or a 0 depending on the numbers found in Table 1. </p>
  
  <p>I am using the following formula at present:</p>
  
  <pre><code> =IF(ISNUMBER(SEARCH("1",A2)),1,0)
  </code></pre>
  
  <p>The next column contains the following:</p>
  
  <pre><code> =IF(ISNUMBER(SEARCH("2",A2)),1,0)
  </code></pre>
  
  <p>All the way to 11</p>
  
  <pre><code> =IF(ISNUMBER(SEARCH("11",A2)),1,0)
  </code></pre>
  
  <p>The problem with this however is that the code for finding references to 1 also find the references to 11. Is it possible to write a formula that can tell the difference so that if I have the following in Table 1:</p>
  
  <pre><code> 2, 5, 11
  </code></pre>
  
  <p>It doesn't put a 1 in column 1 of Table 2?</p>
  
  <p>Thanks.</p>