Ignore letter value in cell?

Question

HTML

I made sure that in the cell, the exchange rate is updated every hour according to cbr data, but now I need to make the product of the current exchange rate multiplied by the number of dollars (convert to rubles), but the data from cbr was loaded not just numbers, but "rub. 56.0794" due to the fact that there are literal values ​​in the cell, it is impossible to calculate the product, if you remove it manually, then when the data is updated (in an hour), "rub" appears again, how can this be fixed?

Answer 1

Trim the string, cut the first 4 characters and multiply the rest by 1.
macros-vba.ru/nadstrojki/excel/279-kak-obrezat-sim...

Answer 2

Suppose the rate is in cell A1.
Then make a service cell (for example, B1) in which you specify the formula: = RIGHT (A1; DLSTR (A1) -5)
This formula will return the value in B1 by cutting off "rub." 5 for the correct number)