formula extract number

Hello in the attached sheet in column S there are numbers with letters:
001>
C100
C100
C100
100
100
C100
005>
I ask for help to extract the number and then insert it into the corresponding cell of column X
john

Hi bo_ry
error #N/D

Ok bo_ry is almost correct.
because if the cell format is percentage, the number becomes + 100?
example your formula 1 with percentage becomes 100%
example your formula 100 with percentage becomes 10000%

Hi alkey it's ok.
it is possible to add to the formula if the value is 0 or empty the word "NOT TREATED" is inserted

Hi Alkey the new formula work!
is it possible to add a change?
Now works:
if S3 is zero or empty add "NOT TREATED" otherwise put the formula.
The modica: if M3 is empty do not put "NOT TREATED" and the formula.
john

Hi bo_ry not work remains "NOT TREATED"

Hi error #N/D

italian: =SE(O(S5={"";0});"NOT TREATED";SE.ERRORE(-CERCA(1;-DESTRA(S5;{1;2;3;4}));-CERCA(1;-SINISTRA(S5;{1;2;3;4})))/100)
english: =IF(OR(S5={"",0}),"NOT TREATED",IFERROR(-LOOKUP(1,-RIGHT(S5,{1,2,3,4})),-LOOKUP(1,-LEFT(S5,{1,2,3,4})))/100)
if:

>100>
C100>
C50>

john

Hi alkey not work
if M3/S3 empty in X3 = NOT TREATED
case: C100> no work
attach esample.
john

unfortunately it must work on merged cells

Hi bo_ry it's o.k, thanks you
A greeting
john

Hi I tried your formula in a workbook but I can not solve a problem.
Now your formula is in sheet1 column X
In the M / S columns there are formulas that join the rows of the sheet2.
The problem is that if in the M / S columns there are some errors like #NAME! then your formula does not work.
I enclose the example.
john

If in M3/M4 Sheet2 there is error in M3 Sheet1 must see only 1 row without error

Hi bo_ry work well
Now the problem is only for the word NOT TREATED
In X3 sheet1 if M3/S3 sheet2 are empty in
X3 sheet1 does not have to see the word NOT TREATED
john

BO_RY your new formula work.
Not work for this case:
If M3 and S3 is empty or M3 not empty and S3 is empty

=IF((((M3=" ")+(S3=" "))OR((M3>0)+(S3=" "))),"",IFERROR........

not work error.

in no case does NOT TREATED come out

Hi
this formula:

=IF(M3="","",IFERROR(1/(1/-LOOKUP(1,-MID(S3,MIN(FIND({0,1,2,3,4}+{0\5},S3&1/17)),{1,2,3,4}))*100),"NOT TREATED"))

if M3 is empty inserts NOT TRATED if not empty inserts the formula.

I request a change.
if M3 and S3 are empty, do not insert NOT TREARED and do not enter the formula, it must remain empty.
if M3 is not empty and S3 is empty, enter NOT TREATED
if M3 and S3 are not empty, enter the formula.

Hi bor_ry

What about if M3 is empty and S3 is not empty?

no this case

Hi bo_ry
the last modification should be correct.
To be sure, I have to try it in the office next week
Greetings and thanks.
john