title: Excel formula to split cell text based on char count
body: <p>Currently around 500 chars in my cell and i would like to split anything over 255 chars into the next cell. The below just duplicates the cell value if over 255 chars and does not split it.</p>
  
  <pre><code>=IF(LEN(A1)&gt;255,A1,"")
  </code></pre>
  
  <p>Don't want to use the UI split text feature as i need to run multiple times and its so time consuming.</p>
  
  <p>Appreciate any assistance.</p>
  
  <p>Cheers~</p>