title: Display each digit in a separate column in a row in Google Sheets
body: <p>I have a column of data in binary values and I would like to split each digit of the number in the column into different cells across a row. How would I go about doing so? I saw the split function, but could not get it to work. <a href="https://support.google.com/docs/answer/3094136" rel="nofollow noreferrer">https://support.google.com/docs/answer/3094136</a>?</p>
  
  <p>One of my example inputs:</p>
  
  <pre><code>1000111110100101111011110
  1000110000100101000010000
  </code></pre>