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

HI

 

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. 

 

Thanks

By: Rakesh Shah

Leave a Reply

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