title: Split one column into two based on numbers and letters
body: <p>Basically, I am trying to remove all the numbers at the end of rows and store them in another column.</p>
  <p>So I initially have something like this at the start:</p>
  <pre><code>Original List
  Dr Pepper;1234
  Pepsi 90s Drink001
  Coca Cola
  Red Bull R3 Drink
  Mountain Dew;11
  Gatorade
  Fanta
  Crush Soda456
  </code></pre>
  <p>I then want to split it so I get one list solely for the soft drink names and then one list solely for numbers at the end. So something like this:</p>
  <pre><code>Soft Drinks
  Dr Pepper
  Pepsi 90s Drink
  Coca Cola
  Red Bull R3 Drink
  Mountain Dew
  Gatorade
  Fanta
  Crush Soda
  </code></pre>
  <p>And then any numbers that appear at the list like:</p>
  <pre><code>Numbers
  1234
  1
  
  
  11
  
  
  456
  </code></pre>
  <p>I know you can use <code>=ARRAYFORMULA(REGEXEXTRACT(A:A&amp;&quot;&quot;,&quot;[a-zA-Z\s]+&quot;))</code> but then it wouldnt get <code>Red Bull R3 Drink</code> for example and instead get <code>Red Bull R</code></p>