Need help Extract numbers

[kdm5g]

I want to extract a list from J6 to K6 and so on. The list varies an
can change so i just want to extract the number here is part of the lis

High (4)
Extreme (2
High (7

 

[Ron Rosenfeld]

I want to extract a list from J6 to K6 and so on. The list varies and
can change so i just want to extract the number here is part of the list

High (4)
Extreme (2)
High (7)

You can use a formula to extract the number. The following formula assumes that your numbers are positive, and that there will be no more than three characters in the numeric expression. If there are more than three characters, then merely extend the array constant near the end (the one that presently looks like {1,2,3}.

This formula must be **array-entered**:

=MAX(IFERROR(--MID(J6,MIN(FIND({1,2,3,4,5,6,7,8,9,0},J6&"1234567890")),{1,2,3}),""))

----------------------------------------

To **array-enter** a formula, after entering
the formula into the cell or formula bar, hold down
<ctrl><shift> while hitting <enter>. If you did this
correctly, Excel will place braces {...} around the formula.

 

[kdm5g]

It worked great, however I have numbers ranging up to 20. How do
change that?! Thanks for all your help!

;1603479']On Mon, 9 Jul 2012 15:49:14 +0000, kdm5

I want to extract a list from J6 to K6 and so on. The list varies and
can change so i just want to extract the number here is part of th list

High (4)
Extreme (2)
High (7)-

You can use a formula to extract the number. The following formul
assumes that your numbers are positive, and that there will be no mor
than three characters in the numeric expression. If there are more tha
three characters, then merely extend the array constant near the en
(the one that presently looks like {1,2,3}.

This formula must be **array-entered**:

=MAX(IFERROR(--MID(J6,MIN(FIND({1,2,3,4,5,6,7,8,9,0},J6&"1234567890")),{1,2,3}),""))

----------------------------------------

To **array-enter** a formula, after entering
the formula into the cell or formula bar, hold down
<ctrl><shift> while hitting <enter>. If you did this
correctly, Excel will place braces {...} around the formula

 

[Ron Rosenfeld]

It worked great, however I have numbers ranging up to 20. How do I
change that?! Thanks for all your help!

I must not have understood something from your description.

Please show the exact types of entries that you are having a problem with, the result of using the formula, and your expected output.