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

Leave a Reply

Your email address will not be published. Required fields are marked *