How to ignore non-numeric characters in a number?

O

old_stalin2020-12-16 22:29:56

excel

old_stalin, 2020-12-16 22:29:56

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

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

D

Dmitry Dobryshin, 2020-12-16
@old_stalin

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

B

BasiC2k, 2020-12-16
@BasiC2k

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.