Forum Discussion
Solved
Extract number from a text after symbol "X/x”
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 sa...
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.
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.