title: How to sum numbers with text appended in the same cell [Excel]?
body: <p>I've tried summing numbers for the entire column by using the sum() function but I get 0 as an answer due to a string present.</p>
  
  <p>Example : </p>
  
  <ul>
  <li>1.99 USD</li>
  <li>22.37 USD</li>
  <li>2.49 USD</li>
  <li>1.69 USD</li>
  </ul>
  
  <p>Is there a function that only calculates/sum the number?
  Thanks</p>