How do I extract the numbers from the right side of the cell

D

Dave L

I need to be able to either set a variable value or use a formula that will
extract only the numbers that appear prior to the first "X" in a cell
starting from the right. For example:

3.5X16X6 Would return 6
15233.5X16X28 Would return 28
3.5X16X10.5 would return 10.5

Any ideas?
 
E

Elkar

Try this:

=MID(A1,FIND("~",SUBSTITUTE(A1,"X","~",LEN(A1)-LEN(SUBSTITUTE(A1,"X",""))))+1,999)

HTH,
Elkar
 
Top