How to extract a number from a text string in google sheet



In my google sheet A1 cell, this is written. 


<!–td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}–>Get 48.81 rupees per dollar on your first transaction. This rate won’t
last, send today!


I want to get the just the number 48.81 in A2. What formula should I put in A2 to get that number 48.81 extracted in cell A2. 



By: Rakesh Shah

4 thoughts on “How to extract a number from a text string in google sheet

  1. ig

    Hello I am so thrilled I found your website, I really
    found you by accident, while I was looking on Aol for something else, Anyways I am here
    now and would just like to say thank you for a
    tremendous post and a all round enjoyable blog (I also love the theme/design), I don’t
    have time to browse it all at the minute but I have book-marked it and also included your RSS feeds,
    so when I have time I will be back to read more, Please do keep up the awesome job.

  2. Demetria

    Thanks a lot for sharing this with all of us you actually
    understand what you are speaking about! Bookmarked. Please also discuss
    with my site =). We may have a link alternate agreement among us

Comments are closed.