title: Split binary number into multiple digits in excel
body: <p>I have a decimal number and I can convert it into binary using DEC2BIN(cell value) function in excel.
  Right now it gives the binary value in a single cell, instead, I want each digit in the binary number into multiple cells.</p>
  
  <pre><code>Data:
  
    A          |B         |C       |D       | E      --- Excel Columns
  1|21
  2|DEC2BIN(A1)
  3|
  4|
  </code></pre>
  
  <p>Current result:
      Data:</p>
  
  <pre><code>  A          |B         |C       |D       | E      --- Excel Columns
  1|21
  2|10101
  3|
  4|
  </code></pre>
  
  <p>Desired Result:
      Data:</p>
  
  <pre><code>  A          |B         |C       |D       | E      --- Excel Columns
  1|21
  2|1          0          1        0        1
  3|
  4|
  </code></pre>
  
  <p>Is this possible? If so how?</p>