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

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?

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

Try this:

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

HTH,
Elkar


"Dave L" wrote:

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?

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

Worked perfect. Thanks!