title: How to remove text/characters from an Excel cell
body: <p>I am looking for a way to remove any text from a cell and leave just numbers. So far I have found a few examples, but they either target predefined text or specialized characters.</p>
  
  <pre><code>SUBSTITUTE(A1, ".", "")
  SUBSTITUTE(text, old_text, new_text, [nth_appearance])
  </code></pre>
  
  <p>Example, my cell can contain mixed text and numbers in any position, so how do I just leave the numbers and remove any characters...</p>
  
  <pre><code>lorem1001ipsum
  ipsum01lorem
  0101lorem
  </code></pre>