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

G

Guest

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?
 
G

Guest

Try this:

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

HTH,
Elkar
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula for extracting text formated numbers within ( )'s as numbe 5
Splitting text and numbers from a cell 6
Formula to extract number values only 8
To extract the number if there is niumeric in right most digits 4
Extracting numbers from a cell with carriage returns 4
how do I extract data from worksheet to VBA? 4
How to extract zip code from a 1 cell adress line? 2
How do I extract a string from an IP address in Excel? 2

Top