title: Any way for Excel to evaluate a number in a text string?
body: <p>I have a cell containing:
      January
      15,5%
      (204 cases)</p>
  
  <p>I want to use conditional formatting and fill this cell if its smaller than the value in another cell:
      5%</p>
  
  <p>This would be an easy task if the first cell only contained the value 15,5%. But is it there any way I can make Excel evaluate just the percentage in a cell?</p>
  
  <p>Thanks. </p>