title: Extracting decimal numbers from a string in Excel
body: <p>I've tried lots of searches for this but I'm still not coming up with anything that works.</p>
  
  <p>I have a range of strings in Column A</p>
  
  <pre><code>Amend.Clause_1.1.AddMCQ
  Amend.Clause_1.1.AddNo
  Amend.Clause_1.1.AddRepeat
  Amend.Clause_1.13.AddRepeat
  Amend.Clause_1.13.AddTitle
  Amend.Clause_1.13.AddUTQ
  Amend.Clause_2.8.Heading_Edit
  Amend.Clause_2.8.MCQ
  Amend.Clause_2.8.Remove
  Amend.Clause_4.26.AddUTQ
  Amend.Clause_4.26.Heading_Edit
  Amend.Clause_4.26.MCQ
  Amend.Clause_5.15.AddMCQ
  Amend.Clause_5.15.AddNo
  Amend.Clause_5.15.AddRepeat
  </code></pre>
  
  <p>As you can see, the numbers always start in the same place, after the underscore "_" at position 13. </p>
  
  <p>I need to extract the decimal numbers from these strings into a new column so I'm left with 1.1, 1.13, 1.14, 4.26 etc.</p>
  
  <p>I've tried all sorts of combos of MID, LEFT, LEN, RIGHT but to no avail, trying to find the position of the last period.</p>
  
  <p>Could anyone explain how to accomplish this? Ideally I'd like to do this without VBA.</p>
  
  <p>Thanks </p>