title: Strip 3 numeric values from string - excel
body: <p>Ive got the below string in a Google drive spreadsheet in cell D1, what im trying to do is strip out the low the high and the average into cells F1,G1,H1</p>
  
  <blockquote>
    <p>Currently, we can provide valuations on 3, across a range of prices:
    from  £4,694,700 to £8,091,700 - Average price £6,624,100</p>
  </blockquote>
  
  <p>At the moment im using <code>=RIGHT(D1, 11)</code> in cell <code>H1</code> to get the average <code>£6,624,100</code> number, but im not sure of the best way to get the others, or how to deal with hundreds of thousands, or tens of millions </p>
  
  <p>Is there a more versatile way this could be done ?</p>
  
  <p>Ive made a dummy spreadsheet here : 
  <a href="https://docs.google.com/spreadsheets/d/1r_RbMjI-7KLNt8QMyQzn0d-AN1CsOxbVfjYXyoIXXFU/edit?usp=sharing" rel="nofollow">https://docs.google.com/spreadsheets/d/1r_RbMjI-7KLNt8QMyQzn0d-AN1CsOxbVfjYXyoIXXFU/edit?usp=sharing</a></p>
  
  <hr>
  
  <p>Ive marked this as an excel question as ive found 99% of the functions that you can use in Excel you can use in Google Spreadsheets (Google spreadsheets cant use excel macros though..) </p>