How to ignore non-numeric characters in a number?

Question

excel

There is a cell with value 2000 р.. How to check if it is greater than 1200, ignoring р.?

Answer 1

For example, with this formula:
=VALUE(LEFT(A1;SEARCH(" ";A1)-1))>1200

Answer 2

It is not entirely correct to store both the value and the unit of measure in a cell. For example, you can specify the currency format and "p." in the cell format with a number. will be set automatically. But it won't affect the calculations.