Find Second Number Set in Cell

[dwgnome]

Trying to isolate the second number in cell.

If I have 48X144X68 in J10, I need 144.

I tried:

=MID(J10,FIND("X",J10,2)+1,3) which works, but when a cell has 65X50X68, then I get 50X where I only want 50.
The numbers can vary in size (i.e., 1 to 5 digits) but always separated by an X or some letter.

Thanks,

Excel 2003

 

[barry houdini]

Here's one way.....

=REPLACE(LEFT(J10,FIND("X",J10,FIND("X",J10)+1)-1),1,FIND("X",J10),"")

 

[Gary's Student]

To get the digits between the "X"'s

=MID(J10,FIND("X",J10)+1,FIND("X",J10,FIND("X",J10)+1)-FIND("X",J10)-1)

 

[T. Valko]

Trying to isolate the second number in cell.

If I have 48X144X68 in J10, I need 144.

I tried:

=MID(J10,FIND("X",J10,2)+1,3) which works, but when a cell has 65X50X68, then I get 50X where I only want 50.
The numbers can vary in size (i.e., 1 to 5 digits) but always separated by an X or some letter.

Thanks,

Excel 2003

Here's another possibility...

=--TRIM(MID(SUBSTITUTE(A2,"X",REPT(" ",100)),100,100))

 

[dwgnome]

Thank you all for your quick response. They all work perfectly.

However, for neatness I used Biff's solution - only requiring one input "X".

 

[T. Valko]

Thank you all for your quick response. They all work perfectly.

However, for neatness I used Biff's solution - only requiring one input "X".

You're welcome. Thanks for the feedback!