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?