Extract number from a text after symbol "X/x”

[Kowsivenus]

I have the following text in a column, where I need to extract number next to second "X", in this text, it is 54.

40sHT + 2/20sCMD X 30sHT + 2/20sCMD 56 X 54 54" AWM/C129-DOBY

Some other sample text were,

21sOE X 12sFL 56 X 36 63" PLAIN - Result must be : 36

40sC X 40sC_100 X 91_63" PLAIN - Result 91

16sOE x 12sLY 84 x 48 71" 3/1 DRILL - Result 48

Regards,

Kowsi

[#2 · Accepted solution]

@Kowsivenus 

Let's say the first value is in A1.

In another cell in row 1, enter the formula

=IFERROR(--TRIM(LEFT(SUBSTITUTE(SUBSTITUTE(TRIM(RIGHT(SUBSTITUTE(UPPER(A1),"X",REPT(" ",255),2),255)),"_"," ")," ",REPT(" ",255)),255)),"")

This can be filled down.