Help with formula for extracting number value in cells that contains both text and number

Originally Posted by Glenn Kennedy

I think you may have given us a very poor sample.

after "part of specific text = "1404.52 Liters.

Is that " ACTUALLY present in the cells?, no i added them for showing wich part of specific text to look for.

Is there ALWAYS only one number in the text?, no there is also other numbers like time and date.

Is there ALWAYS only one word after the number?, Yes the word after the numbers i need to extract is always one.

Is it ALWAYS Liters?, Yes the number i need will always end with Liters.

Hi !
sorry if the sample i provided was confusing..

Regards:
Jan Ove