title: VALUE! Ignore text in excel cell calculation
body: <p>I often run into <code>VALUE!</code> errors in my calculations because they contain numbers and text. How can I leave the text in the cell and proceed with the calculation?</p>
  
  <p>For example:</p>
  
  <p>cell <code>A1</code> contents look like this: <code>101.1 J</code> </p>
  
  <p>cell <code>A2</code> contents look like this: <code>500 U</code></p>
  
  <p>cell <code>A3</code> contents look like this: <code>0.2</code></p>
  
  <p>If I want to add <code>A1</code>+<code>A2</code>+<code>A3</code> into cell <code>A4</code>, how can I ignore the <code>J</code> and <code>U</code> to calculate <code>101.1</code>+<code>500</code>+<code>0.2</code> to get <code>602.3</code> in cell <code>A4</code>?</p>
  
  <p>Thanks!</p>