Hi All,

I've got a rather large spreadsheet of data that contains both text and numerical values, and basically, what I would like to do is find a formula that will allow me to extract the numerical values from the row.

For instance; if cells D - J in row 1 contain the Phrase: Please (D1) Choose (E1) 2 (F1) OR (G1) 4 (H1) OR (I1) 8 (J1), How could I construct a formula that would return 2 in cell A1, 4 in cell B1 and 8 in cell C1? The formula would need to be dynamic though, as there is no set serie of numbers that it would be drawing from (ie, in rows 2,3 etc.. the numbers in those cells could be completely different, or the actual phrase could have changed in which case the numerical value would be in a different column in the range).

Many Thanks!