On Mon, 9 Jul 2012 15:49:14 +0000, kdm5g wrote:


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&"12345678 90")),{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.