extract numbers in a cell containing alphanumeric data

This monster:

Formula:

Please Login or Register  to view this content.

will work for any prefix (I, or multiple letters, or with spaces after the letter) and will return the "number as displayed" i.e. 21.0. It will also work with more complex "numbers", like 21.4.4 and will display that.

BUT... it MUST have a space after the number...

Less of a monster, but one which must be array entered (CTRL + SHIFT + ENTER) and which also falls over if there's no space after the last digit

Formula:

Please Login or Register  to view this content.

A little bit shorter non-array formula

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

Row\Col	A	B
1	I21.4 Acute subendocardial myocardial infarction	21.4
2	I21.0 Acute transmural myocardial infarction of anterior wall	21
3	I21.4 Acute subendocardial myocardial infarction	21.4
4	I21.0 Acute transmural myocardial infarction of anterior wall	21
5	werwr25.045 werwr	25.045
6	poipoipopi35.256 test,test	35.256

If the referenced text will ALWAYS begin with a letter, a number, and a space
this regular formula returns the value between the letter and the first space:

Please Login or Register  to view this content.

Is that something you can work with?